Select the age from birthday in mysql ?

Hi, following  is user table: CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fname` varchar(255) NOT NULL, `mname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `birthday` date NOT NULL, PRIMARY KEY (`id`) ); insert one row into Read more…