> 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...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to