Lua I need a sql query.

[husam]

Hello Otland community.
I wounder if anyone can give me an query that can do this:
find ITEMID and replace it by ITEMID
Thanks. For sure rep++++eace:

 

[despion0]

Players:

UPDATE `player_items` SET  `itemtype` =  'NewID' WHERE `itemtype` ='OldID';

Depots:

UPDATE `player_depotitems` SET  `itemtype` =  'NewID' WHERE `itemtype` ='OldID';

 

[husam]

Thanks!

 

[Grehy]

Thanks!

You will also need to execute it for house items