I think this works too: Select * from Tablename where drinks <> 'pepsi';
> -----Original Message----- > From: Andrew Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2003 4:49 PM > To: '[EMAIL PROTECTED]' > 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'; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php