Sort column ascending but I want 0 to come last and RANDOMLY using mysql

Question

I need to get data from MySQL table in ascending order but zero values come last and randomly

Right now this is my order by condition.This is not working

ORDER BY sortorder=0 RAND(),sortorder

This question will marked as low quality. Please provide more information. Help us to help you. — Wahyu Kristianto, Jun 10 '18 at 11:27
Hmm. No code, no sample data no actual output - nothing to go on — P.Salmon, Jun 10 '18 at 11:28

M Khalid Junaid · Answer 1 · 2018-06-10T12:17:12.187

2

Use conditional ordering

select *
from table
order by column > 0 desc, column asc, rand()

Add rand() at the end

Or you could use union

(select * from table where column > 0 order by column asc)
union all
(select * from table where column = 0 order by rand())

edited Jun 10 '18 at 12:17

answered Jun 10 '18 at 11:28

M Khalid Junaid

i need zero column value data randomly – Aishu Jun 10 '18 at 11:32
I need 0 value data only come last and randomly.In that demo complete data showing randomly – Aishu Jun 10 '18 at 12:14

Shoukat Mirza · Answer 2 · 2018-06-10T11:50:29.917

0

If you want to get data from mysql randomly and zero values come last. You may want to try the following:

SELECT * FROM table ORDER BY `column` = 0, rand();

edited Jun 10 '18 at 11:50

answered Jun 10 '18 at 11:33

Shoukat Mirza

I need Zero value data only randomly – Aishu Jun 10 '18 at 11:35
Not complete data randomly – Aishu Jun 10 '18 at 11:35
then add where condition where column = 0 – Shoukat Mirza Jun 10 '18 at 11:39
I have zero value data and other data also.Zero value data should come last and randomly – Aishu Jun 10 '18 at 11:41
`SELECT * FROM table where column = 0 ORDER BY `column` = 0, rand();` – Shoukat Mirza Jun 10 '18 at 11:41
by using above code will get column` = 0 values only – Aishu Jun 10 '18 at 11:43
If you remove the where condition then the query will get all data and zero value data will come in the last randomly – Shoukat Mirza Jun 10 '18 at 11:47
Then complete data will get randomly.I need 0 values only randomly.rest all asc order – Aishu Jun 10 '18 at 11:50

2 Answers2