关于MySql列别名做查询条件的问题

[xiaosong8023]

假如有这样一条sql语句
select name as name1 from table1 where name1='aaa'
mysql中不可以这样使用别名,那可不可以用其他什么方式来代替

[nianzhang747]

mysql> select b.n as n from ta,(select name n from ta) b where b.n="name1" and
a.name=b.n;
+-------+
| n     |
+-------+
| name1 |
+-------+
1 row in set (0.00 sec)

别名放在表后面

[ACMAIN_CHM]

select name as name1 from table1 where name1='aaa'

没有办法，只能用原来的列名。

select name as name1 from table1 where name='aaa'

[vinsonshen]

字段别名不能直接在谓词部分引用
你的这个查询可以改成这样：

select name as name1 from table1 having (name1='aaa');

[xiaosong8023]

谢谢大家的回复.
1楼的方法可行,我开始就试了.
3楼更加好.