/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

-1 vote330 views1 answer
Su: Authentication failure mysql
SQL
3 votes339 views3 answers
C# sql select
SQL
0 vote331 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
7 votes296 views1 answer
Alter table add key sql
SQL
0 vote340 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote347 views1 answer
How to to get time in sql
SQL
11 votes356 views6 answers
Distinct sql
SQL
0 vote337 views1 answer
Heidisql check how much space a row
SQL
0 vote332 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote328 views2 answers
Postgresql get long running queries
SQL