PHP：每天一次随机结果，

Question

PHP: I know RAND() function will return the result in random order. But I want to get the Random Result once a day. So every day there will be different order but that order should be fixed for that day. [SELECT * FROM Table_Name ORDER BY RAND();]

How can I achieve this, Is there any way to do it.?

Answer 1

hope this helps

select * from TABLE order by rand(dayofyear(CURRENT_DATE)) limit 1