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
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
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
Select statement paramter
Hi guys, I was wondering if anyone knew of a paramter that can be put on the end of a select statement when querying a table which only pulled out one unique record based on a field. I.e If i had a drink database and in it were 10 cokes 10 fantas 10 pepsi's what select statement would i need to pull out 1 coke,1 fanta,1 pepsi . Thanks for your help, a virtual beer to whoever answers my question :) Andrew Wilson Technical Support Netway Networks 8920-8877 Netway Networks Pty Ltd (T) 8920 8877 (F) 8920 8866 - 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
