问个mysql的问题

SELECT * FROM cities WHERE LOCATE('new', name)> 0 ORDER BY LOCATE('new', name) 

如何把两个 LOCATE('new', name) 缩写 为 LOCATE('new', name) as i 的形式？

如果不缩写是不是会计算两次？

我写的错误代码如下
代码:

 SELECT name, LOCATE( 'new', name ) AS i0
FROM cities
WHERE i0 >0

MySQL said: Documentation
#1054 - Unknown column 'i0' in 'where clause'

试过了，似乎是MySQL不支持这种用法。