I have a below db table structure : Tablename : agency_mst Fields: id name is_premium date_added I

Question

I have a below db table structure : Tablename : agency_mst Fields: id name is_premium date_added I

want to sort the data so that the agencies with is_premium=1 comes first and the rest of the data is sorted by date_added desc order.
But also the is_premium=1 records should be sorted in random order. so first set of premium agencies will have random order. Is this possible to do in MySQL query?

0

16.08.2017