mysql speicific select with order

Question

I have table products with column price. It have rows with values:

What params with select should I use to get result like this:

`SELECT ... FROM products WHERE ... ORDER BY price` – Wodin Nov 24 '17 at 10:55 — Wodin, Nov 24 '17 at 10:55
order by `col_name` asc – Bhanuchander Udhayakumar Nov 24 '17 at 10:56 — Bhanuchander Udhayakumar, Nov 24 '17 at 10:56

score 4 · Accepted Answer · answered Nov 24 '17 at 10:56

4

You could first order by 0 & then rest

SELECT * FROM <table> ORDER BY CASE WHEN price = 0 THEN 1 ELSE 0 END,price

answered Nov 24 '17 at 10:56

Yogesh Sharma

juergen d · Answer 2 · 2017-11-24T14:20:31.857

3

select * from products
order by price = 0, price

edited Nov 24 '17 at 14:20

answered Nov 24 '17 at 10:55

juergen d

score 0 · Answer 3 · answered Nov 24 '17 at 11:00

0

Try it

SELECT *
FROM test
ORDER BY IF(price=0,999999999,price)

answered Nov 24 '17 at 11:00

Sergey Menshov

3 Answers3