How to display data randomly?

Question

Ruby on Rails

Suppose I display some data
data=Data.all
. I will display data sorted by ID. And how to display all the data randomly? And so that every time everything is randomized?
If anything, I use kaminari, so making a random array for the array will not work.

Answer 1

Use the capabilities of your DBMS.
MySQL PostgreSQL
Data.order('RANDOM()').all