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
mysql-query
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