Solved Commad Phpmyadmin, simple

[Vrotz]

I need to delete several players of the same vocation of my database. How thiscommand for insert in the phpmyadmin?

 

[Xon vanetta]

DELETE FROM `players` WHERE `vocation` = 2

2 is the number you wanna delete.

But evryone with the same vocation will be deleted.

 

[Vrotz]

By example, the sorcerer (2) will be deleted but the master sorcerers also?

 

[Nottinghster]

@ZyzzBR

No, will delete only sorcerers!

1 - SORCERER
2 - DRUID
3 - PALADIN
4 - KNIGHT
5 - MASTER SORCERER
6 - ELDER DRUID
7 - ROYAL PALADIN
8 - ELITE KNIGHT

 

[Vrotz]

But i need deleted just knights and paladins ;S

 

[Ninja]

DELETE FROM `players` WHERE `vocation` IN ("3", "4");

 

[Vrotz]

Thanks, Solved.