mysql> SELECT ((year(curdate())-year('1982-06-05')) - (right(curdate(),5) < right('1982-06-05',5))) as umur; +------+ | umur | +------+ | 28 | +------+ 1 row in set (0.00 sec)