Re: Remove all instances of a character....
| From: | CPT John W. Holmes | Date: | Wed, 24 Dec 2003 13:27:21 +0000 |
| Subject: | Re: Remove all instances of a character.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32181@lists.php.net to get a copy of this message | ||
From: <Tristan.Pretty@risk.sungard.com>
> I have a MySQL database, with around 500 entries in one table...
> I've noticed that many entries have an erroneous ';' in the one of the
> fields.
>
> What I need to do, is tell MySQL to go through the ENTIRE table and find
> any instances of ' ; ' and them delete them... leaving the rest of the
> data intact.
UPDATE TABLE SET column = REPLACE(column,' ; ','')
Reminder: This is a PHP list...
---John Holmes...