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
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
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