/SQL/Order by number of character in sql

Order by number of character in sql

You can also sort or order by the Number of Characters in each Column you wish 
to sort by. Shown below is a sample which sorts by the first three characters 
of the First Name and by the last two characters in the name of the town.

    SELECT *
    FROM table_name
    ORDER BY LEFT(FirstName, 3) ASC, LEFT(Town, 2);

Similar codes

0 vote269 views1 answer
Find number of entries sql
SQL
0 vote326 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote297 views1 answer
Mssql unique key accept nulls
SQL
1 vote278 views1 answer
Mariadb case switch
SQL
1 vote299 views1 answer
Second last highest id in sql
SQL
4 votes269 views1 answer
Oracle error compilation line
SQL
-1 vote282 views1 answer
How to switch user in mysql
SQL
1 vote282 views1 answer
Mysql copy table1 to table2
SQL
1 vote288 views1 answer
Generate random data postgresql
SQL
19 votes290 views6 answers
Create table sqlite
SQL