Title: Sql Statement To Update Html In Post
Last modified: August 18, 2016

---

# Sql Statement To Update Html In Post

 *  [ebg](https://wordpress.org/support/users/ebg/)
 * (@ebg)
 * [19 years, 9 months ago](https://wordpress.org/support/topic/sql-statement-to-update-html-in-post/)
 * 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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Austin Matzko](https://wordpress.org/support/users/filosofo/)
 * (@filosofo)
 * [19 years, 9 months ago](https://wordpress.org/support/topic/sql-statement-to-update-html-in-post/#post-449385)
 * `UPDATE wp_posts SET post_content=REPLACE(post_content, '<BR>', '<br />');`
 *  Thread Starter [ebg](https://wordpress.org/support/users/ebg/)
 * (@ebg)
 * [19 years, 9 months ago](https://wordpress.org/support/topic/sql-statement-to-update-html-in-post/#post-449401)
 * Thank you, worked perfect!!!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Sql Statement To Update Html In Post’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [ebg](https://wordpress.org/support/users/ebg/)
 * Last activity: [19 years, 9 months ago](https://wordpress.org/support/topic/sql-statement-to-update-html-in-post/#post-449401)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics