[RESOLVED] Show only if day = Monday

[Mark_Nordstrom]

Heres my query.

SELECT *, DATE_FORMAT(event_start_date, '%M %d %Y') AS date FROM cal_events WHERE event_calendar_id='2' AND event_start_date <= '$date1' ORDER BY event_id ASC LIMIT 5

Now I wanna do is only show dates that the day = mon, wed, fri.

[Derokorian]

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

WHERE DAYOFWEEK(event_state_date) IN (2,4,6)

[Mark_Nordstrom]

Thanks works perfect.