Order by rand() in Model query

How to get some random entries from the database?

I put RAND() in the Order field, but the result is this:

ORDER BY `model`.`RAND`()

Hi megana,

I don't think that you can do this without hacking the CC code. If you are loading all the records then you could shuffle them using PHP but that won't work if you are only loading a sub-set.

Bob

Thanks Bob, that's really annoying! Luckily I don't have many records total, so pulling them all and then using array_rand() or shuffle() in the pre display processing should work in this case.