SELECT * FROM TABLE WHERE Table_ID IN( '1', '2', '3' ) also check the NOT IN syntax. Ignatius ____________________________________________ ----- Original Message ----- From: "shaun" <shaun@mania.plus.com> To: <php-db@lists.php.net> Sent: Wednesday, April 09, 2003 10:11 PM Subject: SELECT Statement > Hi, > > what is the best way to select rows with an unknown number rowIDs? > > e.g. SELECT * FROM TABLE WHERE Table_ID = '1', '2', '3' > > Thanks for your help > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
