Re: SELECT Statement
| From: | Jim Hunter | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: SELECT Statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26964@lists.php.net to get a copy of this message | ||
If it were me, I would use the IN clause and make a list of the items to
choose from. Your SQL would look like:
SELECT * FROM table WHERE Table_ID IN ('1','2','3')
hope this helps
Jim
-------Original Message-------
From: shaun
Date: Wednesday, April 09, 2003 13:17:53
To: php-db@lists.php.net
Subject: [PHP-DB] 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
.