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] Remo
[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: www.amazon.com
W. Holmes
Cc: [EMAIL 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 b
;;',
'' )' at line 1
==
"CPT John W. Holmes" <[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
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
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 instanc
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