1 2 3 4 5
DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( a DATE ); SELECT * FROM t1 WHERE ( SELECT a FROM t1 ) IN ('2012-04-25','2012-04-26'); a DROP TABLE t1;