Re: query for multiple values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:  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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux