View Single Post
Old 05-14-2012, 01:19 PM  
roly
Confirmed User
 
Join Date: Aug 2002
Posts: 1,844
Quote:
Originally Posted by xJerk View Post
You could do

ORDER BY RAND(CURDATE())

But there are some major performance implications with doing this with a large table (unless the query results are cached).
got it sorted thanks, but that's a new one i've never heard of which i'm sure will have its uses.
roly is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote