How do I locate instances of <CR><LF><LF> in a mysql longtext field

Posted by Ilane on Stack Overflow See other posts from Stack Overflow or by Ilane
Published on 2010-06-16T18:10:12Z Indexed on 2010/06/16 18:12 UTC
Read the original article Hit count: 242

Filed under:

I would like to query my table for how many rows contain one or more instances of <CR><LF><LF>. I can't figure out the correct syntax. I would try

LIKE '%<CR><LF><LF>%',
but I don't know how to specify these special characters. I did try
where mydata REGEXP '%[.CR.][.LF.][.LF.]%',
and that didn't get a syntax error but neither did it return any rows. So, I realized I need a way to insert the test data as well!

Note: I am using mysql 5.0.

© Stack Overflow or respective owner

Related posts about mysql-query