/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 vote347 views1 answer
Sql string function update replace
SQL
0 vote348 views1 answer
Default order by in mysql
SQL
3 votes341 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote324 views1 answer
Sql create text column limited values
SQL
0 vote336 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
9 votes332 views1 answer
Mysql check date range
SQL
1 vote326 views1 answer
How to unlock table in mysql
SQL
0 vote303 views1 answer
Hangfire clean script
SQL
0 vote363 views1 answer
Create a view in sqlite
SQL
0 vote311 views1 answer
Sql remove first character from string
SQL