Jump to content



Member Since 17 Jul 2009
Offline Last Active Jul 04 2013 06:47 AM

Topics I've Started

SQL question to replace text in a field...............

04 July 2013 - 06:33 AM

I've searched the internet, and came up with these SQL statements, but number 2 won't work.

I'm trying to, in the full_description field, replace "type:" with "genre:".

1 - SELECT * FROM cscart_product_descriptions WHERE full_description like '%type:%';
2 - update cscart_product_descriptions set full_description = replace(full_description, 'type:', 'genre:')

What is the correct SQL statement ?

Thank you, Duaine