Re: query for multiple values
| From: | Ignatius Reilly | Date: | Wed, 15 Oct 2003 22:15:35 +0000 |
| Subject: | Re: query for multiple values | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31034@lists.php.net to get a copy of this message | ||
SELECT *
FROM table
WHERE column IN ( 'this', 'that', 'theother' )
Ignatius
_________________________
----- Original Message -----
From: "Robbie Staufer" <rstaufer@scd.ucar.edu>
To: <php-db@lists.php.net>
Sent: Thursday, October 16, 2003 12:10 AM
Subject: [PHP-DB] query for multiple values
> Hi,
>
> Is there a way to construct a mysql query that will select * for
> multiple values in the same column?
>
> For example: "SELECT * FROM table WHERE column = 'this' and 'that'
> and
> 'theother'"
>
> Thanks,
> Robbie
>
> --
> -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> Robbie Staufer
> NCAR/SCD
> 1850 Table Mesa Dr. Rm. 42
> Boulder, CO. 80305
> (303) 497-1836
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>