I’ve been doing data cleansing of one of my project. Then there was a need to find some abbreviation to be replaced by the real words.
Here I did with mysql statement.
update property set town = replace(town,’tmn’,’taman’)
update TABLENAME set FIELDNAME = replace (FIELDNAME, searchstr, replacestr)