MYSQL Queries

Example:

MySQL query – Add string before, after existing data

UPDATE table SET field=CONCAT(‘<text<![CDATA[<p>’,field,'</p>]]><text>’)