phpmyadmin - Find and replace <p> with return key entry in MySQL -


i have implemented nl2br(htmlspecialchars(... display user entered mysql data. annoyingly various posts littered

tags before knew nl2br. there quick way scan through mysql (i use php myadmin) , replace <p> return key entry nl2br picks on? there

tags in 1 of columns. thanks

edit: example

...d wood on front car cracked - has stood test of time well.  <p> such ancient coaster, affords surprisingly ride – relic can still deliver.. 

so <p> should removed , replaced empty line

given example, <p> elements not necessary. can replaced \n:

update yourtable set thecolumn = replace(thecolumn, '<p>', '\n') 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -