[OpenBD] Re: Best way to randomize results from cfsearch collection

[ben.8]

Are all 10k+ records 2 weeks old? What SQL engine?

For MySQL Could do something like:

SELECT column FROM table
WHERE dteCreated <= #dateadd("ww", -2, now())#
ORDER BY RAND()
LIMIT 20

-- 
official tag/function reference: http://openbd.org/manual/
 mailing list - http://groups.google.com/group/openbd?hl=en