Search for literal line break string in mysql
Posted: Mon Dec 26, 2011 10:31 pm
I've a bunch of malformed table fields with the actual string "\r\n" in them. How can I search for the literal string (results show that I am searching for an actual line break and not the literal representation of them)?
I've tried:
[text]WHERE `field` LIKE '%\r%'[/text]
and \\r and \\\r and etc. Only tried matching the \r first because once i get that right i can add the \n in it.
I've tried:
[text]WHERE `field` LIKE '%\r%'[/text]
and \\r and \\\r and etc. Only tried matching the \r first because once i get that right i can add the \n in it.