Results 1 to 1 of 1
Thread: Order By Rand() - Solution Found
Jun 14, 2004, 14:39 #1
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
Order By Rand() - Solution Found
If the Order By Rand() sorting in MySQL has frustrated you (like it has done to me), then I am very hopeful that the following will work for you. It works for me perfectly.
ORDER BY rand(" . time() . " * " . time() . ") LIMIT 1
The above was taken from a user post on the MySql site and is greatly appreciated.