how to sort data in alias column on mysql

so i have been learning mysql syntax about a 5 days now and there is this LENGTH function in mysql that count string length in the column like this:

SELECT id, LOWER(NAME) AS 'Name Lower', LENGTH(NAME) AS 'Name Length' FROM products;

generated 2024-01-06 15:03:33 by HeidiSQL 12.6.0.6765

which lower string on column NAME and alias it to display as Name Lower column, next counting string length in NAME column and display it as alias ‘Name Length’ which is informative for me and i wonder how about i want to sort this alias column ?

then i tried this command;
SELECT id, LOWER(NAME) AS 'Name Lower', LENGTH(NAME) AS 'Name Length' FROM products
ORDER BY 'Name Length';
but it won’t sort the Name Length like what i want it to be.

so the solution is using back ticks, just like mention here in mysql docs.

this is the command to sort alias column in mysql using backticks:
SELECT id, LOWER(NAME) AS 'Name Lower', LENGTH(NAME) AS 'Name Length' FROM products
ORDER BY `Name Length` desc;

generated 2024-01-06 15:13:20 by HeidiSQL 12.6.0.6765