Order numbers after letters

[gin]

I have a table:

 

SELECT * FROM table ORDER BY sort;
+------+
| sort |
+------+
| 1    |
| 2    |
| aaa  |
| bbb  |
| ccc  |
+------+

 

I want to make the numbers appear after the letters, like so:

+------+
| sort |
+------+
| aaa  |
| bbb  |
| ccc  |
| 1    |
| 2    |
+------+

 

Please advise.

[fenway]

ORDER BY FIELD(sort, sort) ASC.

 

Bizarre casting.

[gin]

It works... for this example anyway, and I have no idea why...

 

Could you elaborate? I'm trying to apply this to my actual query, and it's not working at all

[gin]

AUGH, I apologize! I was looking at the wrong column used for sorting! It wasn't numbers vs letters at all. it was numbers vs. NULL. Below is my solution.

 

Actual table

SELECT * FROM table ORDER BY sort;
+------+
| sort |
+------+
| NULL |
| 1    |
| 2    |
| 3    |
+------+

 

Placing the null at the bottom:

SELECT * FROM `table` ORDER BY (CASE WHEN sort IS NOT NULL THEN 1 ELSE 0 END) DESC;
+------+
| sort |
+------+
| 1    |
| 2    |
| 3    |
| NULL |
+------+

[fenway]

It works... for this example anyway, and I have no idea why...

 

Could you elaborate?

If you include this expression in your SELECT column list, you'll see why.