[EMAIL PROTECTED]
24/12/2003 13:27
Please respond to
CPT John W. Holmes [EMAIL PROTECTED]
To
[EMAIL PROTECTED], [EMAIL PROTECTED]
cc
Subject
Re: [PHP-DB] Remove all instances of a character
From: [EMAIL PROTECTED]
I have a MySQL database, with around 500 entries in one table...
I've
PROTECTED]
Subject: Re: [PHP-DB] Remove all instances of a character
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
[EMAIL PROTECTED] wrote:
Tried that but I got an error when using PHPMyAdmin...
UPDATE risk_corpdatacapture email = REPLACE(email,';','')
just don't work???
You're missing SET...
UPDATE risk_corpdatacapture SET email = REPLACE(email,';','');
--
---John Holmes...
Amazon Wishlist:
THAT'S IT!!!
Sweet...
Xmas hangover be damned... got there in the end..!
Cheers everyone, happy new year!!!
John W. Holmes [EMAIL PROTECTED]
29/12/2003 13:11
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
[EMAIL PROTECTED]
Subject
Re: [PHP-DB] Remove all instances
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
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
From: [EMAIL PROTECTED]
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