RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!

Or rawurldecode()? http://us4.php.net/manual/en/function.rawurldecode.php > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@Getingeusa.com] > Sent: Thursday, July 31, 2003 3:21 PM > To: php-db@lists.php.net > Subject: RE: [PHP-DB] updating a column based on info from another > coluimn ? Desperate! > > > Will urldecode() work for you on the PHP side or do you have > to convert > everything in the database? > > http://us4.php.net/manual/en/function.urldecode.php > > > -----Original Message----- > > From: Aaron Wolski [mailto:aaronjw@martekbiz.com] > > Sent: Thursday, July 31, 2003 3:14 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] updating a column based on info from > > another coluimn? > > Desperate! > > > > > > 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 > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >