Re: Remove all instances of a character....

Try this : mysql_query("DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'"); Saygilarla, Muhammed Mamedov ----- Original Message ----- From: <Tristan.Pretty@risk.sungard.com> To: <php-db@lists.php.net> 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 mysql.org, 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. > *********************************************************************** > >