Replace a Character in a MySql Database field

In one of my MySql databases I need to replace one character in one specific field with another set of characters. With around 600 records I did not want to do this manually. A google search found the following solution (as yet untested, only posted as a reminder):

SQL:

update <table_name>
set <field> = replace(<field>,'original','new');

replace <table_name> with table name, and <field> with the field you are targeting.

(this solution was found on http://www.vinhboy.com/blog/item/2008/05/how-to-fix-strange-characters-in-mysql-database



Edited 1 time(s). Last edit at 08/28/2008 03:52PM by m8ty.

... yes ... it worked!!!