From: <[EMAIL PROTECTED]>
> 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
> 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...
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php