RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!
| From: | Hutchins, Richard | Date: | Thu, 31 Jul 2003 19:21:01 +0000 |
| Subject: | RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29590@lists.php.net to get a copy of this message | ||
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
>
>