I have a table with the folowing fields:
ft_id(INT), from_date(VARCHAR(45), to_date(VARCHAR(45), cost(VARCHAR(45)
ft_id from_date to_date cost
1 05-05-2017 15-05-2017 60
now today is 11-05-2017, if this date is lies between from_date and to_date then i need to fetch the cost of that row