Database Cleanup

I ran a couple of queries to get rid of the (now un-needed) <br /> tags I had in posts and comments from b2. I think it went fine but let me know if you see anything that looks out of place.

To clean up your posts table (assuming you are using a ‘wp_’ table prefix):

UPDATE `wp_posts`
SET `post_content` =
REPLACE(`post_content`, '<br />', '');

To clean up your comments table (again, assuming you are using the ‘wp_’ table prefix):

UPDATE `wp_comments`
SET `comment_content` =
REPLACE(`comment_content`, '<br />', '');

Note: This will remove all of the <br /> tags, so make sure that is really what you want to do. 🙂