Using NOT in mysql

[mrdance]

I tried this line but it didn't return any results;

$qry= mysql_query("SELECT KONTROLL FROM likvid WHERE NOT KONTROLL='TOM' ORDER BY DATUM", $db);

Any suggestions..?

[trippyd]

try
$qry= mysql_query("SELECT KONTROLL FROM likvid WHERE KONTROLL != 'TOM' ORDER BY DATUM", $db);

notice the != instead of the NOT, should fix the problem.

[Anon]

<> also works for not equal

[mrdance]

thanx!