If you are looking to make search based on day and month and wants to neglect year like you want to search all records between 2 March to 10 September under any year.
$schFrm = '2015-03-02'; //You can specify any year like 2015, 1980, 2005 etc
$schTo = '2015-09-10'; //You can specify any year like 2015, 1980, 2005 etc
SELECT * FROM your_db_tbl WHERE DATE_FORMAT( `date` , '%m-%d') BETWEEN DATE_FORMAT('".$schFrm."', '%m-%d') AND DATE_FORMAT('".$schTo."', '%m-%d' )
0 Comment(s)