there's this wonderful thing called IN. learn it, love it.

SELECT * FROM foo WHERE myDate in ('01-aug-2006','08-aug-2006')