/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

18 votes145 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
8 votes109 views1 answer
Similarities between ddl and dml
SQL
0 vote169 views1 answer
How to check database engine in mysql
SQL
2 votes145 views1 answer
No data found oracle
SQL
1 vote123 views1 answer
Oracle finding duplicate records
SQL
21 votes160 views4 answers
Add column mssql
SQL
-1 vote139 views1 answer
Mac mysql workbench console
SQL
2 votes140 views6 answers
In in sql
SQL
0 vote165 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
-1 vote150 views4 answers
Restart mysql server ubuntu
SQL