I have a
CRON task that needs to extract customers with birthdays in a given month, from a MySQL InnoDB table. The birthday field is indexed and of type
Filtering for April, I can query the customers table either by:
SELECT * FROM customers WHERE birthday LIKE "2015/04/%";
SELECT * FROM customers WHERE MONTH(birthday) = 4;
Which one would you recommend, and why?