Convert date in date list condition to list of date ranges
SUGGESTION #1

SELECT A.* FROM table1 A INNER JOIN
(
    SELECT '2015-03-01' dtcolumn
    UNION SELECT '2015-03-15'
    UNION SELECT '2015-04-01'
    UNION SELECT '2015-04-15'
    UNION SELECT '2015-05-01'
) B ON
A.dtcolumn &gt;= B.dtcolumn
AND A.dtcolumn &lt; B.dtcolumn + INTERVAL 1 DAY;


SUGGESTION #2

SELECT * FROM table1 WHERE
(column &gt;= '2015-03-01' AND
column &lt; '2015-03-01' + INTERVAL 1 DAY)
UNION
SELECT * FROM table1 WHERE
(column &gt;= '2015-03-15' AND
column &lt; '2015-03-15' + INTERVAL 1 DAY)
UNION
SELECT * FROM table1 WHERE
(column &gt;= '2015-04-01' AND
column &lt; '2015-04-01' + INTERVAL 1 DAY)
UNION
SELECT * FROM table1 WHERE
(column &gt;= '2015-04-15' AND
column &lt; '2015-04-15' + INTERVAL 1 DAY)
UNION
SELECT * FROM table1 WHERE
(column &gt;= '2015-05-01' AND
column &lt; '2015-05-01' + INTERVAL 1 DAY);