Sign In
Find content
Not Telling
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
|
|
