Negate an WHERE blah IN()

[Anon]

$Names = implode($Name, "','");
$result = mysql_query("DELETE FROM Table WHERE Name IN('$Names');",$db);

Thats what im using to delete certain records ,.. id like to be able to delete all but certain ones instead ?

[baruch]

Read the manual buddy (RTFM!)

s/IN/NOT IN/

[Anon]

Hi,
I'd rather hesitate on this, but I've ever read that subselect (IN()) is not suppoted in MySQL. Correct me if i'm wrong