0

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.

JPro
  • 6,292
  • 13
  • 57
  • 83
  • Was this the result of an SQL injection attack, perhaps? If so, more repair may be needed than just fixing that one table, and prevention would need to be considered. – Paul Feb 15 '10 at 11:33

1 Answers1

0

Are you looking for REPLACE(str,from_str,to_str)

Adriaan Stander
  • 162,879
  • 31
  • 289
  • 284