Can we use aliased field to use in ORDER BY clause in MySQL?

Question

Can we use aliased field name in ORDER BY clause?

For example:

SELECT id, name AS firstname
FROM users
ORDER BY firstname

Is it possible? When I tried this it errored out.

Answer 1

An alias can be used in a query select list to give a column a different name. You can use the alias in GROUP BY, ORDER BY, or HAVING clauses to refer to the column.

Check here.