I have recently been shown some code by experts that searches for carriage returns or breaks in a MySQL database:
WHERE description LIKE CONCAT('%',CHAR(10) , CHAR(10) , '%')
I have also tried the CHAR(13) and
WHERE description LIKE '%\r\r%'
also trying \n\n as well
When I do it with a single break, it gives me lots of returns but none with the double returns. I know double breaks exist in the db because when rendered in HTML they appear:
<p>...... - lovely old houses, narrow streets, a lovely church etc. <br><br><br></p>
Any ideas how to identify which records have double breaks or why the above code is not picking these multiple breaks up?