William Eaton - Scripts & Function

Find and replace in mysql

To find certain characters or strings and replace them with another value, execute the following query…

update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘);

This is quite useful for finding strange characters that appear instead of letters with accents over them. I usually replace the strange character with the ASCII value (á becomes á)