please tell me can we create function based index in my sql if yes then how...? if no the why..? i want to create index on this query, here we have a my sql query--
$sql="select count(opportunity_code) as opc, month(created) as mon from tbl_oppourtunities where abs(DATEDIFF(date(now()),created)) <= 365 and year(created)=year(now())";
please reply me asap .