[SOLVED] Help with SQL query please

[Randaal]

Hi, could someone please give an SQL query that:

In table: ps_product_lang
Only for: id_lang=4

Sets for: available_now

 

a specific term

 

I have created this language after many of my products were created and it contains Czech words instead of English (ID 4), so I would like to bulk change this whole column ONLY in English so I don't need to manually set every single product separately.

 

I hope you understand what I need :-) thanks

[Randaal]

I've done it. I am not sure if it helps someone but here is the query:

UPDATE `database_name`.`ps_product_lang` SET `available_now` = 'Your Message Here' WHERE `ps_product_lang`.`id_shop` = 1 AND `ps_product_lang`.`id_lang` = 4;

For shop ID #1, and language ID #4

[vekia]

thank you for posting solution and for this brilliant query

i marked topic as solved.