Re: How? Select every saturday between two dates

[Rick James]

SELECT count
    FROM tbl
    WHERE date >= '2011-01-01'
      AND date <  '2012-01-01'
      AND WEEKDAY(date) = 5;   -- Saturday