MySQL, replacing with... nothing (delete those, please!)
- by javipas
I'm trying to purge my WordPress content from "false" carriage return (CR). These are caused after a migration of my content, that now presents from time to time a code that makes the web rendering engine to "paint" a CR where I would like to be nothing. The paragraphs seem to have a double CR because of this, and look too far apart.
I'd like to be able to make a MySQL query in order to get rid of that strings, but at the moment I haven't found the key. What I've tried is
UPDATE wp_posts set post_content = replace (post_content,' ',' ');
But i get
<p> </p>
where before were the strings. This seems not the answer at all. Could it have to be with the ampersand, and in that case, should I use something like &nbsp; or something similar?