SQL command!

[mahant]

Hey
I need sql command that will delete players, without 4 names. ANyone? Please help


2.

Delete all player_items, without items with player id = x, y, z, a (samples)


I want to delete players and player_items without samples

 

[mahant]

need help really fast, c'monn..

 

[PineIt]

Change the 'SampleX' parts.

DELETE `players`, `player_items` FROM `players`, `player_items` WHERE `players`.`id` = `player_items`.`player_id` AND `players`.`name` NOT IN( 'Sample1', 'Sample2', 'Sample3', 'Sample4' );

 

[mahant]

#1054 - Unknown column 'player_items.id' in 'where clause'

 

[PineIt]

Sorry, mistyped one of the columns. Try now.

 

[mahant]

Great job bro, thanks.

Can u tell me as fast command which will delete every player, which has level 14 and more?

##edit
It didn't delete player_items :d But it's not important now, i have to delete all players 14>

 

[PineIt]

DELETE `players`, `player_items` FROM `players`, `player_items` WHERE `players`.`id` = `player_items`.`player_id` AND `players`.`level` >= 14;

 

[mahant]

I want only players ... :> Players which are 14, and more too

 

[PineIt]

DELETE FROM `players` WHERE `level` >= 14;

 

[mahant]

Love yah xd repp+