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

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -