How to display materials in random order?

Question

MySQL

Friends, hello everyone!
Can you tell me how to randomize content? listing below:

$query->order($db->quoteName('a.featured') . ' DESC')->order($db->quoteName('a.publish_up') . ' DESC');

Answer 1

It seems to work:

$query->order('a.featured DESC,' . $query->rand());

Answer 2

Well, remove the sort. Will be in the order of entry in the table.

Answer 3

ORDER BY RAND(), this is not the fastest operation, but if the query will be executed frequently, it can be accelerated