Page 1 of 1

how to search year through query?

Posted: Wed Jun 02, 2010 12:41 am
by adilmarwat2004
I have table name merit and has four fields as

roll, name, marks, date_retire(date).
2 Neil 326 02-06-2015
3 Jhon 312 06-11-2013


I want to use query like that which Select date_retire by year not day or month.

please help

Re: how to search year through query?

Posted: Wed Jun 02, 2010 1:54 am
by Christopher
Something like "SELECT * FROM merit WHERE YEAR(date_retire)='$year' " ?