/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

3 votes228 views3 answers
1396(hy00) mysql error
SQL
1 vote201 views1 answer
Group_concat max length mysql
SQL
0 vote209 views1 answer
How to remove default in mysql
SQL
0 vote200 views1 answer
Sql query to delete row by id
SQL
18 votes199 views6 answers
Creating table in MySQL
SQL
0 vote197 views1 answer
Mysql remove tabs from string
SQL
0 vote234 views1 answer
Postgres list users and roles
SQL
7 votes201 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote249 views1 answer
How to subquey to do not load in live database in
SQL
5 votes193 views4 answers
Describe table postgres
SQL