[Boofo]

So, this is one of those rare times where 2 queries are actually better than one.

From what I have read on it, it is supposed to be even more random than the ORDER BY RAND(). But what would this do against a table that has missing IDs or empty rows?

--------------- Added [DATE]1274156362[/DATE] at [TIME]1274156362[/TIME] ---------------

Andreas,

I just ran the EXPLAIN for the queries and this is what I got:

lcg_value
Results: 2 (0.0001s)
1 PRIMARY - Impossible WHERE noticed after reading const tables
2 SUBQUERY - Select tables optimized away


ORDER BY RAND
Results: 1 (0.0001s)
1 SIMPLE - (table)quote - (type)ALL - (rows)1912 - Using temporary; Using filesort

I don't understand what the lcg_value info means. Is it bad or good?