Re: Remove all instances of a character....

["John W. Holmes" <holmes072000@xxxxxxxxxxx>]

Tristan.Pretty@xxxxxxxxxxxxxxxx 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/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

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