/ Published in: SQL
sometimes we botch an import, and end up with return or newline characters in the field. So fields which should be empty have \r in them, or fields with text data have an invisible trailing newline. This makes it impossible to match the text values. This sql statement removes the \r characters in a field.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
UPDATE TABLENAME SET COLUMNNAME = REPLACE(COLUMNNAME, '\r', '');