List:General Discussion« Previous MessageNext Message »
From:Jasper Bryant-Greene Date:October 24 2005 4:14am
Subject:Re: Not operator in Select statements
View as plain text  
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

Jasper Bryant-Greene
General Manager
Album Limited

e: jasper@stripped
p: 0800 4 ALBUM (0800 425 286) or +64 21 232 3303
a: PO Box 579, Christchurch 8015, New Zealand

Not operator in Select statementsDotan Cohen24 Oct
  • Re: Not operator in Select statementsJasper Bryant-Greene24 Oct
    • Re: Not operator in Select statementsDotan Cohen24 Oct