/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 vote165 views1 answer
Drop view in mysql
SQL
1 vote164 views2 answers
Mysql remove first and last character from string
SQL
3 votes226 views2 answers
Oracle sql first day of month
SQL
-1 vote153 views2 answers
Postgres autoincrement primary key
SQL
0 vote197 views1 answer
Sql track modification
SQL
0 vote157 views2 answers
Disallowed function mysql to_date()
SQL
2 votes154 views2 answers
Sqlalchemy filter or
SQL
0 vote195 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote178 views2 answers
Insert data mysql with cmd
SQL
0 vote152 views1 answer
Make a socket server to detect changes in mysql
SQL