RE: where drink is not equal to pepsi
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
RE: where drink is not equal to pepsi
Lol, I keep the cookie. I was just looking for the != syntax.. -Original Message- From: Andrew Wilson Sent: Friday, March 21, 2003 11:49 AM 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'; Driving me batty.. A cookie for the right answer.. t 8920 8877 f 8920 8866 e [EMAIL PROTECTED] w http://www.netwaynetworks.com.au - 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 t 8920 8877 f 8920 8866 e [EMAIL PROTECTED] w http://www.netwaynetworks.com.au - 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
RE: 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'; 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
RE: where drink is not equal to pepsi
Select * from Tablename where drinks != 'pepsi'; Got any milk with that cookie? -Original Message- From: Andrew Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 6: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'; Driving me batty.. A cookie for the right answer.. t 8920 8877 f 8920 8866 e [EMAIL PROTECTED] w http://www.netwaynetworks.com.au - 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 - 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
RE: where drink is not equal to pepsi
Lol.. beat me by 2 minutes.. Can i fed-x that cookie ? -Original Message- From: Jon Wagoner [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 11:54 AM To: Andrew Wilson; [EMAIL PROTECTED] Subject: RE: where drink is not equal to pepsi Select * from Tablename where drinks != 'pepsi'; Got any milk with that cookie? -Original Message- From: Andrew Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 6: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'; Driving me batty.. A cookie for the right answer.. t 8920 8877 f 8920 8866 e [EMAIL PROTECTED] w http://www.netwaynetworks.com.au - 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 t 8920 8877 f 8920 8866 e [EMAIL PROTECTED] w http://www.netwaynetworks.com.au - 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