Thanks Jason
I can use that but lots of records are already in the table and mySql does not seem to have a find and replace like access has.
I expect it will be a copy column into Excel
Find and replace
Then copy colum and paste back into Mysql column.