mysql - 我想操作 table1 中的 "AS age"列

Question

下面是我写的查询

SELECT *, YEAR(CURDATE()) - YEAR(age) AS age FROM table1

我想从上面的查询中操作“年龄”列

例如:

SELECT  * FROM table1 WHERE age BETWEEN 1 AND 9

我怎样才能从这个查询中做到这一点

SELECT *, YEAR(CURDATE()) - YEAR(age) AS age FROM table1

我的结果将返回包含年龄范围的行

Answer 1

您可以将查询用作子查询，例如

SELECT t2.* FROM
( SELECT t1.*, YEAR(CURDATE()) - YEAR(age) AS age FROM table1 t1 ) t2
WHERE t2.age BETWEEN 1 and 9