/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

2 votes159 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
36 votes151 views6 answers
Rename table sql
SQL
1 vote138 views1 answer
Woocommerce mysql price table
SQL
-3 votes136 views1 answer
Remove spaces sql 2008
SQL
7 votes164 views5 answers
Max 3 salary in sql
SQL
0 vote173 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
2 votes144 views2 answers
Sql first character
SQL
1 vote163 views1 answer
Delete dublicate rows sql
SQL
0 vote179 views1 answer
Consulta alias con inner join
SQL
11 votes147 views3 answers
Sql_mode=only_full_group_by
SQL