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 > 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
