EXCEPT AND MySQL

[panagiotis ne]

Hello,
I want to select all records EXCEPT some. Can I do that with MySQL?


Here is my query:
$result2 = mysql_query("SELECT id_armodiotitas from armodiotites EXCEPT SELECT perigrafi,id_armodiotitas FROM armodiotites,armodiotites_users WHERE iduser = '$id' AND id_armodiotitas=idarmodiotitas");


And I get this error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXCEPT ( SELECT perigrafi,id_armodiotitas FROM armodiotites,armodiotites_users W' at line 1

Can anyone help me?