Try this :
mysql_query("DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'");
Saygilarla,
Muhammed Mamedov
----- Original Message -----
From: <Tristan.Pretty@xxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Wednesday, December 24, 2003 1:12 PM
Subject: 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.
> ***********************************************************************
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
