mysql::SQLでcase文を初めて使った記念日。
SELECT CASE WHEN MONTH(rdate)<4 THEN YEAR(rdate)-1 WHEN MONTH(rdate)>3 THEN YEAR(rdate) END as `年度` FROM `dates` WHERE 1
SELECT CASE WHEN MONTH(rdate)<4 THEN YEAR(rdate)-1 WHEN MONTH(rdate)>3 THEN YEAR(rdate) END as `年度` FROM `dates` WHERE 1