> Hi guys, > Hopefully have an easy question for you guys. > Whats wrong with this query > > > Select * from Tablename where drinks is not = 'pepsi'; > > Driving me batty..
select * from CaseSensitiveTablename where drink != 'pepsi'; or select * from CaseSensitiveTablename where drink not like '%pepsi%'; (the above to be a little wilder) If that doesn't work - what kind of error are you getting? --------------------------------------------------------------------- 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