Search for date this week

[trygve]

Trying to figure out how to dynamically query for birthdays in the range of this week (Sun - Sat) out of MySQL. Date of birth (dob) is a date field. So if the query ran on Tuesday 2003-06-02 it would qualify on last sunday's month and date 06-01 through next sat's month and date 06-07.

[Bunkermaster]

SELECT 
    `peeps`.`name`
FROM
    `peeps`
WHERE
    WEEK( `peeps`.`bday` ) = '4'

or something 😃