Try this :

mysql_query("DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'");

Saygilarla,
Muhammed Mamedov
----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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.
> ***********************************************************************
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to