Solved Query to delete a certain item from all players.

[AnarchGov]

I was wondering if there is a query i can run in my database to delete an item from all players?

If so, could anyone share please? Thanks in advanced.

REP++

Just incase i didn't explain well enough, here is an example:

Say an item is bugged in your server, and the items id is 2222. I am looking for a way to delete this item from all of my players(who may have it) in my database.

-------------------------------------------------------------------------

Solved by ninja. Thanks again.

 

[Ninja]

DELETE FROM `player_items` WHERE `itemtype` = "2222";

 

[AnarchGov]

Thank you ninja. I will rep you as soon as it lets me .

Btw, this is just a one time query right? It won't do it like every restart or save right?

 

[Ninja]

Yes, it is only for one time.

 

[AnarchGov]

This query did not work. :/