Tried that but I got an error when using PHPMyAdmin...

UPDATE risk_corpdatacapture email = REPLACE(email,';','')
just don't work???

Wll confused now, cuase that's what I tried before I posted to the list... 
and you guys say it should work too...

Any other ideas?
SQL-query :  
UPDATE risk_corpdatacapture email = REPLACE ( 
MySQL said: 
You have an error in your SQL syntax.  Check the manual that corresponds 
to your MySQL server version for the right syntax to use near '=  REPLACE 
( email,
 '' )' at line 1

"CPT John W. Holmes" <[EMAIL PROTECTED]> 
24/12/2003 13:27
Please respond to
"CPT John W. Holmes" <[EMAIL PROTECTED]>


Re: [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.

UPDATE TABLE SET column = REPLACE(column,' ; ','')

Reminder: This is a PHP list...

---John Holmes...

PHP Database Mailing List (
To unsubscribe, visit:

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.

Reply via email to