I wouldn’t mind having such an option myself.
Try this, but make a backup first.
update wp_posts set post_content = replace(post_content, '<br />', '');
Mike
Thank you ever so much. Including comments corrected I had a total of 500 breaks removed 🙂
Nice! Good job Mike, I didn’t know you could do that directly in SQL.
I (heart) the UPDATE function. 😀
http://www.mysql.com/doc/en/UPDATE.html
To be clear, that’s two single quotes at the end of his query, not a double quote.
Amaaaaaaaaaaaaazing:
“Affected rows: 869 (Query took 0.0298 sec)”
Less than three hundredths of a second. Oi.
i’m an sql noob
where am i supposed to put the…
update wp_posts set post_content = replace(post_content, ‘
‘, ”);
…thing?
It actually should be this:
UPDATE wp_posts SET post_content = REPLACE(post_content, '<br />, '');
or for old school HTML, this:
UPDATE wp_posts SET post_content = REPLACE(post_content, '<br>', '');
And it’s a SQL query for use on your database. If you have access to a tool like phpMyAdmin, go into your WordPress database through it, click the SQL tab, and enter the query there.
Note: Backing up your database first is ALWAYS a good thing.
