Web Developer Blog

SELECT
	CASE
		WHEN STR_TO_DATE(CONCAT(YEAR(NOW()),'-',MONTH(birth_date),'-',DAY(birth_date)),'%Y-%m-%d') < NOW()
			THEN STR_TO_DATE(CONCAT(YEAR(NOW()),'-',MONTH(birth_date),'-',DAY(birth_date)),'%Y-%m-%d') + INTERVAL 1 YEAR
		ELSE STR_TO_DATE(CONCAT(YEAR(NOW()),'-',MONTH(birth_date),'-',DAY(birth_date)),'%Y-%m-%d')
	END AS birthday
FROM
	users
ORDER BY
	birthday;