Removing carriage returns in Mysql DB

Question

I am trying to replace the garbage in my DB:

UPDATE xxxxxx set body = replace(body,'<p></p><p>','<p>') 

Some tags are not replaced because there are line breaks between them ...

In phpmyadmin, I see the following:

 yadda yadda<p></p> <p>yadda yadda 

This did not work.

 UPDATE xxxxxx set body = replace(body,'\\r\\n',''); UPDATE xxxxxx set body = replace(body,'\\r',''); UPDATE xxxxxx set body = replace(body,'\\r',''); 

WHERE TO BE DEPARTED?

Any ideas?

Answer 1

 UPDATE xxxxxx set body = replace(body,'\r\n',''); UPDATE xxxxxx set body = replace(body,'\n',''); 

Try the above.

Answer 2

None of them worked for me. Then I realized that I also had breaks in paragraphs ¶. This request worked for me:

 UPDATE xxxxxx SET body = REPLACE(REPLACE(body, '\r', ''), '\n', '');