updating a column based on info from another coluimn? Desperate!

From: Date: Thu, 31 Jul 2003 19:14:24 +0000
Subject: updating a column based on info from another coluimn? Desperate!
Groups: php.db 
Request: Send a blank email to php-db+get-29589@lists.php.net to get a copy of this message
Hi All, This is OT but I am in need of serious help. I am rewriting URL's for a site and came across an issue with spaces in URLS having %20 applied to them. I can't seem to find a solution with mod_rewrite to get rid of the %20 and replace with - (hyphen) so I am hoping someone can help me here with an MySQL solution. I have over 4000 records in a table. I've added a new column in that table called newUrl Is it possible with a QUERY to take from the 'designers' column and write into the 'newUrl' column and replace spaces with - at the same time? I'm probably talking out my a$$ here but I am a little desperate for a solutions. Thanks in advance and again my apologies for the OT message. Aaron

« previous php.db (#29589) next »