somehow wild characters has cropped up in my mysql table while storing UNC path in my table. and all the \r onces are showing up a square in the fields. Can anyone tell me how to fix these please? Thanks.
Are you looking for REPLACE(str,from_str,to_str)