SQL Query group shuffle [closed]

Question

I have a query like

select id, item, producer from table

The result is like this:

  id          item            producer
   1          apple            A
   2          pear             A
   3          peach            A
   4          orange           B
   5          strawberry       B
   6          melon            B

I want to shuffle this result (order by id DESC) and get something like this

item            producer
strawberry       B
pear             A
orange           B
apple            A
peach            A
melon            B

I DON'T want to display like this:

ALL A ITEM

ALL B ITEM

ALL C ITEM...

Answer 1

Use the rand function in ORDER BY like this:

select id, item, producer from table order by rand();

Answer 2

To Shuffle the selection you can use rand()

The Answer for the link below contains more information.

 SELECT id, item, producer 
 FROM table
 ORDER BY RAND()

MySQL: Shuffle a limited query result?