mysql code

[Lucif]

Hello,

 

I need to search and replace a lot in the database and i can use this code:

 

UPDATE ps_product_lang SET meta_title = REPLACE(meta_title, 'aapje', 'beertje');

 

But i have also a condition. The condition is: only replace IF id_shop = 4

 

How can i use that condition in the mysql code?

[pedepot]

Hello,

the Id of shop is stored in the colunm id_shop of the table ps_product_lang. You would need to update your query with the condition WHERE : 

UPDATE ps_product_lang SET meta_title = REPLACE(meta_title, 'aapje', 'beertje') WHERE id_shop=4;

 

I have not tried it. Please check 

 

Best regards

[Lucif]

Thank you, it works!

[pedepot]

I am glad it works! Good luck with Prestashop