I am doing some search in which my requirment is to search between specific dates.
Like user can put start date and then end date. Once submit then it should find result between these two dates.
Select from table where date1>2001-01-05 And date2< 2001-02-05.
Will this above statement will work. Is there any function which subtracts date like this. How mysql function works when we use query like date less than 2001-01-05