SELECT MyDate FROM dates_table WHERE MyDate > start_date AND MyDate < end_date AND DAYOFWEEK(MyDate)=4;