Alias in GROUP BY, ORDER BY, or HAVING clauses not working.

[demmings]

For example:

SELECT CONCAT(last_name,', ',first_name) AS full_name FROM authors ORDER BY full_name

the ORDER BY full_name does not work. However, you can specify:

SELECT CONCAT(last_name,', ',first_name) AS full_name FROM authors ORDER BY last_name. first_name