How to randomly sort records based on the first sort?

Question

MySQL

I select records from the database, I need to sort them so that the records are sorted by date, and if the date is the same, then by chance. Something like this:
SELECT * FROM `news` ORDER BY `date`, rand()

Answer 1

I can't vouch for the speed of execution, but something like this

select *, rand() as orderField  from news order by `date`, orderField