how do i select all the other entries other than specified in the list using IN

[sandeepand]

I have to delete all entries other than specified using a IN statement. If my Mysql query is

SELECT * FROM `service' where id in (122,123,124,125);

I want to select all the other entries with ids other than 122,123,124 and 125 and delete them.

Thanks in advance.

[JKing]

I have to delete all entries other than specified using a IN statement. If my Mysql query is

SELECT * FROM `service' where id in (122,123,124,125);

I want to select all the other entries with ids other than 122,123,124 and 125 and delete them.

Thanks in advance.

Hi there,
You can use the NOT keyword before your IN.

SELECT * FROM `service' 
WHERE id NOT IN (122,123,124,125);