SELECT * FROM your_table
  WHERE
your_date_column BETWEEN X and Y
  AND
DAYOFWEEK(your_date_column) = 4