Re: Not operator in Select statements

2005-10-24 Thread Dotan Cohen
On 10/24/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > 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 y

Re: Not operator in Select statements

2005-10-23 Thread Jasper Bryant-Greene
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 corre

Not operator in Select statements

2005-10-23 Thread Dotan Cohen
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"; $query = "SELECT album, year FROM albums WHERE year NOT 1990 ORDER BY year ASC"; Thanks in advance