Lil' Help with MySQL - Replace()

[AllThingsTrendy]

I am trying to replace content contained in the item description of many of my products. Yet, some of the target replacements contain new lines (\n). I though the REGEXP would work. But, it does not. Rather it returns the following error: "#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'REGEXP '<p class="measurements" align="center">This <span class

". I have read up on REGEXP. If I am understanging properly, it appears that it can only be used in a WHERE clause.

 

Anyone have a clue how to locate the following which contains several \n and the replace it?

 

UPDATE products_description SET products_description = replace( products_description, REGEXP '<p class="measurements" align="center">As with the complete collection,\n this <a href="http://www.allthingstrendy.com/catalog/index.php?cPath=67"><span class="AnthonyDavid">Anthony David</span>® Swarovski crystal accessory</a> makes a great\n gift.</p>', '' )

 

Advice much appreciated!

Thanks,

Wayne