RE: [PHP] select statement
| From: | John Holmes | Date: | Thu, 16 May 2002 11:38:56 +0000 |
| Subject: | RE: [PHP] select statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-97893@lists.php.net to get a copy of this message | ||
Nothing to do with PHP...
SELECT * FROM myTable WHERE ID IN (1,3,7,9);
If you're using MySQL, read the manual:
http://www.mysql.com/documentation/mysql/bychapter/
---John Holmes...
> -----Original Message-----
> From: Wilbert Enserink [mailto:wilbert@pdd.nl]
> Sent: Thursday, May 16, 2002 7:20 AM
> To: php-general@lists.php.net
> Subject: [PHP] select statement
>
> Hi all,
>
>
> I want to select some records with e.g. ID's 1,3,7 and 8
> How can this be done best?
>
> is it: SELECT * FROM myTable WHERE ID=1,3,7,8 ??
>
>
> thx. Wilbert
>
>
> -------------------------
> Pas de Deux
> Van Mierisstraat 25
> 2526 NM Den Haag
> tel 070 4450855
> fax 070 4450852
> http://www.pdd.nl
> info@pdd.nl
> -------------------------