Try this :


Muhammed Mamedov
----- Original Message ----- 
Sent: Wednesday, December 24, 2003 1:12 PM
Subject: [PHP-DB] Remove all instances of a character....

> 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.
> I'll run along to google now, and, but it's xmas eve, and I'm 
> feeling lazy.. ;-)
> Cheers,
> Tris...
> *********************************************************************
> The information contained in this e-mail message is intended only for 
> the personal and confidential use of the recipient(s) named above.  
> If the reader of this message is not the intended recipient or an agent
> responsible for delivering it to the intended recipient, you are hereby 
> notified that you have received this document in error and that any
> review, dissemination, distribution, or copying of this message is 
> strictly prohibited. If you have received this communication in error, 
> please notify us immediately by e-mail, and delete the original message.
> ***********************************************************************

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to