Joomla Jumpstart

Use the MySQL Replace function to find and replace in MySQL.

MySQL Replace function

To use a MySQL statement to remove all paragraph tags:

UPDATE `jos_content` SET introtext = replace(introtext,"<p>","") WHERE `title` REGEXP '-0';

 This can be usefull with Joomla documents -- especially when they are imported into Joomla from another source. 

 Additional Sources

• MySQL Reference manual Replace function 
• How to Find and Replace in MySQL with the Replace function