Orderbybtcountdesc or orderbybtcount failed. Is there any sort statement?

Orderbybtcountdesc or orderbybtcount is invalid. Is there any sort statement? Select & nbsp; * & nbsp; from & nbsp; table & nbsp; where & nbsp; yz = '1' & nbsp; order & nbsp; by & nbsp; bt order by btcount desc or order by btcount is invalid. Is there any sort statement?
Select * from table where yz = '1' order by btcount desc write output is incorrect,

The field btcount is very short. generally, it is = 0 or = 1, and the maximum value is = 8.

When the data volume is large, you cannot sort by the value of btcount greater than. why?

Which can be correctly ordered by time: select * from table where yz = '1' order by time desc

That is, according to btcount cannot be correctly sorted, is it because the length of the btcount field is too short?

However, in phpmyadmin, clicking in ascending or descending order is effective. do you want to know if order by is not used in phpmyadmin for ascending or descending order?


User btcount time id
Aaa 0 1359119507 1
Bbb 2 1359119506 2
Ccc 0 1359119502 4
Ddd 1 1359119501 6
Eee 0 1359119467 7
Fff 3 1359119467 9
Ggg 2 1359116785 13
Hhh 0 1359119687 15

How can I write the correct output? Share:
------ Solution --------------------
Select * from table order by btcount desc