Hi there,

This is a question about how mysql appears to return information in asc or descending order only.
Is it capable of returning the information in random order.
In otherwords. I have a radio field called Listing_Type.
accepted values are Lodging, Events, Retail.
the query returns the links -
in ASC order: Events, Lodging, Retail or
in DESC order Retail, Lodging, Events.

Can it somehow be told to return it in any other order so
that it might return -
Lodging, Events, Retail or
Lodging, Retail, Events?

I can randomly choose an order, (ASC or DESC) but what other option if any is there?

using mysql 3.22.21

thanks for anyones help.

peace.