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