Xampp sql query help

[Nightimarez]

Can someone fix this query, I just can't get it right.

SELECT * FROM `player_items` WHERE itemtype '2173' set count '2'

I want it to set everybody's aol charges to 2.

 

[EvulMastah]

UPDATE `player_items` SET `count` = '2' WHERE `itemtype` = '2173'

 

[Nightimarez]

Thanks. Hey, I was close! XD

 

[Cykotitan]

UPDATE `player_items` SET `count` = '2' WHERE `itemtype` = '2173'

Why so `' ?

UPDATE player_items SET count = 2 WHERE itemtype = 2173

 

[EvulMastah]

Why so `' ?

UPDATE player_items SET count = 2 WHERE itemtype = 2173

I know that you dont need to quote int values, but this is my habit (and also those are security reasons!).

 

[Zonet]

I know that you dont need to quote int values, but this is my habit (and also those are security reasons!).

In some you have to, not sure. Example the player_storage (column key) I tried doing a script, didn't worked until I did with ``