[SQL] query sql

[grzesiek1925]

Hi,
How do I add points premium for people who have more than 200 lvl?
This query is bad...

UPDATE `accounts` SET `premium_points` = premium_points + 200 WHERE `palyers`.`lvl` > '200'

 

[Cykotitan]

UPDATE `accounts` SET `premium_points` = `premium_points` + 200 WHERE (SELECT `account_id` FROM `players` WHERE `level` >= 200 AND `players`.`account_id` = `accounts`.`id` LIMIT 1) IN (`accounts`.`id`);

 

[grzesiek1925]

and how I wanted to give the first 20 points of the person I have give:

UPDATE `accounts` SET `premium_points` = `premium_points` + 200 WHERE (SELECT `account_id` FROM `players` WHERE `level` >= 200 AND `players`.`account_id` = `accounts`.`id` LIMIT 20) IN (`accounts`.`id`);

 

[president vankk]

i dont understand much u, u need give 20 points or 200 points?
Give 20 points to level 200 >

UPDATE `accounts` SET `premium_points` = `premium_points` + 20 WHERE (SELECT `account_id` FROM `players` WHERE `level` >= 200 AND `players`.`account_id` = `accounts`.`id` LIMIT 20) IN (`accounts`.`id`);

credits cyko~

 

[roflmao haha]

i dont understand much u, u need give 20 points or 200 points?
Give 20 points to level 200 >

UPDATE `accounts` SET `premium_points` = `premium_points` + 20 WHERE (SELECT `account_id` FROM `players` WHERE `level` >= 200 AND `players`.`account_id` = `accounts`.`id` LIMIT 20) IN (`accounts`.`id`);

credits cyko~

I know this is really old, but is there a limit for how stupid one can be?