MySQL has a bunch of string manipulation functions for example:

REPLACE(str,from_str,to_str)

Returns the string str with all occurrences of the string
from_str replaced by the string to_str. 

To be able to play around with syntax, make a new column to hold the altered values, then when you get the results you want, delete the original column and rename the new one.