mysql - SQL Query group shuffle -
i have query like
select id, item, producer table
the result this:
id item producer 1 apple 2 pear 3 peach 4 orange b 5 strawberry b 6 melon b
i want shuffle result (order id desc) , this
item producer strawberry b pear orange b apple peach melon b
i don't want display this:
all item
all b item
all c item...
use rand function in order this:
select id, item, producer table order rand();
Comments
Post a Comment