Order by in `varchar` field?

Asked Feb 18 '20 at 11:04

Active Feb 19 '20 at 04:04

Viewed 54 times

I have a table with a field type varchar. Under this field, I have data something like this:

I need to order this column in asc order.

I have used following lines for the order by. But this is not giving me order i need.

ORDER BY LENGTH(state) ASC, state ASC

asked Feb 18 '20 at 11:04

nas

1

@SougataBose, while `CAST`, `CONVERT` or `BIN` are obvious approaches, the link provided does not solve the problem to push `MH90` at the bottom. – mitkosoft Feb 18 '20 at 11:22
`SELECT s.char_field, BIN(s.char_field) AS b FROM strings AS s ORDER BY BIN(s.char_field) = 0, BIN(s.char_field), LENGTH(s.char_field)` – mitkosoft Feb 18 '20 at 11:37
1

For natural sort with MySQL 8 or MariaDB 10 you can try [this](https://stackoverflow.com/a/48602292/5563083) – Paul Spiegel Feb 18 '20 at 12:51
@Paul thanks, I solved it by using the natsort to the final resullt – nas Feb 18 '20 at 13:15
@nas Which "natsort" did you use? From my link? – Paul Spiegel Feb 18 '20 at 14:18

0 Answers0