Lua sql querry

[natanal99]

I want all player from account id x to gain storage id y value 1
can anyone help me?

something like:
db.executeQuery ("UPDATE `player_storage` SET `33002` = '1' WHERE `account_id` = '1' ;")

but "account_id" isn't a "player_storage" field and i don't know how to do it so '----------'

 

[Roddet]

UPDATE `player_storage` LEFT JOIN `players` ON `player_id` = `id` SET `value` = 1 WHERE `key` = 33002 AND `account_id` = 1;

 

[natanal99]

ty