From: Daevid Vincent
Date: March 21 2003 8:35pm
Subject: RE: "where drink is not equal to pepsi
List-Archive: http://lists.mysql.com/mysql/135270
Message-Id: <000701c2efe9$679a5060$dc0aa8c0@Locutus>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I think this works too:

 Select * from Tablename where drinks <> 'pepsi';

> -----Original Message-----
> From: Andrew Wilson [mailto:will@stripped] 
> Sent: Thursday, March 20, 2003 4:49 PM
> To: 'mysql@stripped'
> Subject: "where drink is not equal to pepsi
> 
> 
> 
> Hi guys, 
> Hopefully have an easy question for you guys.
> Whats wrong with this query
> 
> 
> Select * from Tablename where drinks is not = 'pepsi';