When i use the function: ORDER BY id DESC
My post will be like this...
1, 2, 21, 22, etc, 3, ,31, 32, etc, 4, 5 ,6 ,7 ,8.....
Why that?
Thanks
Moderator: General Moderators
Code: Select all
SELECT CAST(id AS UNSIGNED) AS reorderval FROM table ORDER BY reorderval DESC