/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 vote340 views1 answer
Increase existing date in sql
SQL
2 votes337 views2 answers
Postgres add column integer
SQL
0 vote333 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote308 views1 answer
Raw query must include primary key
SQL
2 votes285 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
5 votes314 views1 answer
Oracle create table comment
SQL
0 vote303 views1 answer
Mysql date only no time
SQL
1 vote354 views1 answer
Oracle create program if not exists
SQL
1 vote326 views2 answers
How to combine 2 tables in MySQL
SQL
11 votes317 views3 answers
Sqlite3 create table from another table
SQL