[mysql] Differenza fra due date

[nicola75ss]

prova questa

select utente,( YEAR(CURRENT_DATE)-YEAR(data))- ( RIGHT(CURRENT_DATE,5)< RIGHT(data,5) ) AS eta
from tabella  
( YEAR(CURRENT_DATE)-YEAR(data))- ( RIGHT(CURRENT_DATE,5)< RIGHT(data,5) )
between 15 and 20