On Mon, 2005-10-24 at 06:09 +0200, Dotan Cohen wrote: > How do I use a not operator in the WHERE clause? The obvious != and > NOT didn't work for me. Something along the lines of: > $query = "SELECT album, year FROM albums WHERE year!=1990 ORDER BY year ASC";
The above query is syntactically correct. If it didn't work for you, then your problem lies elsewhere. Perhaps post your error message? By the way, your question would have been answered by reading the manual... -- Jasper Bryant-Greene General Manager Album Limited e: [EMAIL PROTECTED] w: http://www.album.co.nz/ p: 0800 4 ALBUM (0800 425 286) or +64 21 232 3303 a: PO Box 579, Christchurch 8015, New Zealand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
