[PhpMyAdmin] chaning id for items with specifed id

[arheon]

I want to change a crystal coin for platinum for all players but i don't know what should i type in pma.
I tried on my own but im fail in mysql xD.

UPDATE player_items WHERE itemtype = '2160' SET itemtype = '2152'

i tried something like that but it showed error like that :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype ='2160' SET itemtype ='2152'' at line 1

rep + for help

 

[Chris]

UPDATE `player_items` SET `player_items`.`itemtype` = 2152 WHERE `player_items`.`itemtype` = 2160;

 

[arheon]

it works rep ++
solved