/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

12 votes248 views1 answer
Run mysql instance in docker
SQL
0 vote215 views1 answer
Oracle list proxy users
SQL
0 vote241 views1 answer
Sql today at midnight
SQL
0 vote215 views1 answer
Delete data from database sqlite android
SQL
6 votes215 views2 answers
Join vs union
SQL
0 vote209 views1 answer
Download mysql database to excel in android studio
SQL
0 vote206 views1 answer
Mysql update sequence with order by
SQL
10 votes209 views1 answer
Dba_dependencies
SQL
0 vote254 views1 answer
Calculer pourcentage mysql
SQL
0 vote273 views1 answer
Hierarchal database table
SQL