/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

79 votes322 views6 answers
Grepper code
SQL
0 vote142 views1 answer
Sql find gaps in date ranges
SQL
11 votes137 views1 answer
Mysql text type max length
SQL
1 vote136 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote129 views1 answer
Mysql autoincrement valor inicial
SQL
4 votes136 views1 answer
Phone number sql
SQL
-1 vote185 views1 answer
Get month and year from date in mysql sequelize
SQL
5 votes148 views1 answer
AND OR NOT operators sql
SQL
0 vote136 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote139 views2 answers
Sql auto update dupdated_at
SQL