subject:"\[PHP\-DB\] query for multiple values"

Re: [PHP-DB] query for multiple values

2003-10-15 Thread Ignatius Reilly

SELECT * FROM table WHERE column IN ( 'this', 'that', 'theother' ) Ignatius _ - Original Message - From: "Robbie Staufer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16

[PHP-DB] query for multiple values

2003-10-15 Thread Robbie Staufer

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 Tabl