/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 vote160 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote164 views1 answer
SQL joins in python
SQL
0 vote145 views1 answer
Procedures sql insert mysql
SQL
1 vote143 views2 answers
Extract weekday from date in sql
SQL
6 votes152 views2 answers
Insert into select mysql
SQL
0 vote189 views1 answer
Having all mysql
SQL
2 votes132 views1 answer
Sql like variable
SQL
4 votes141 views6 answers
Second max salary in sql
SQL
0 vote137 views1 answer
Connexion mysql
SQL
4 votes143 views1 answer
Find tables with column name in sql
SQL