WordPress.org

Ready to get started?Download WordPress

Forums

Sql Statement To Update Html In Post (3 posts)

  1. ebg
    Member
    Posted 7 years ago #

    I have made some posts with invalid xhtml. Mainly I used <BR> instead of
    . Can anyone tell me specifically the sql statement I would use to update <BR> to
    in phpadmin?

    Thank you,
    ebg

  2. Austin Matzko
    Member
    Posted 7 years ago #

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

  3. ebg
    Member
    Posted 7 years ago #

    Thank you, worked perfect!!!

Topic Closed

This topic has been closed to new replies.

About this Topic