Thx those who answered, what I was looking for is the IN statement
Thanks again --------------------------------------------------------- Chris Kay Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 --------------------------------------------------------- -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 October 2002 12:24 PM To: Chris Kay; [EMAIL PROTECTED] Subject: Re: Select Query At 12:00 +1000 10/3/02, Chris Kay wrote: >Query ( that gets past the anti spam ) > >Question is...... > >I have a select where I want to get ID 15 && id 25 > >Can I do something like WHERE ID = 15,25 > >Or do I have to do WHERE ID = 15 && ID = 25 ... WHERE ID IN (15,25) > >--------------------------------------------------------- >Chris Kay >Techex Communications >Website: www.techex.com.au Email: [EMAIL PROTECTED] >Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 >--------------------------------------------------------- --------------------------------------------------------------------- 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
