mercredi 19 juillet 2023

How to save the order of records after rand()?

I have randomize the order of records in a table using

SELECT * FROM TableA ORDER BY rand();

How do I seva the result table of this query?

When execute the query, I indeed got a shuffle order of the table. But when I visit the page again, it shuffles again and the order change. How do I save the result of just one shuffle?




Aucun commentaire:

Enregistrer un commentaire