26th May 2006

Find and replace text in mysql

update TABLE_NAME set FIELD_NAME =
replace(FIELD_NAME,'find this string','replace it with this one');

Referral text link:

Leave a Reply

Free Anonymous Proxy