Sort by 1 in mysql?

Good day

there is a request

SELECT * FROM table WHERE one > 0 ORDER BY pos ASC

the result of the query:
  • 0
  • 0
  • 1
  • 1
  • 2
  • 3
  • 10


how to make sorting did not work on 0 and 1 and to 0 position was at the end.

Table structure:
CREATE TABLE `tabls` (
 `uid` int(11) NOT NULL,
 `id` bigint(20) NOT NULL,
 `name` varchar(500) NOT NULL,
 `pos` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
June 26th 19 at 14:07
1 answer
June 26th 19 at 14:09
Solution
SELECT * FROM table WHERE one > 0 ORDER BY pos = 0, pos;
0 disappears - Uriah.McGlynn commented on June 26th 19 at 14:12

Find more questions by tags MySQL