My line breaks were in the middle of the string, and I didn’t have control over the source data. The following mysql command worked for me:
REPLACE(FIELD,'\r\n',' ')
My line breaks were in the middle of the string, and I didn’t have control over the source data. The following mysql command worked for me:
REPLACE(FIELD,'\r\n',' ')