Anyone had a problem with combining
SELECT DISTINCT .... ORDER BY RAND()
in a query using MySQL 3.23.x, where 'x' is later than 5?
There's a reference on the MySQL site to fixing a bug involving the
above in 3.23.5, but I'm seeing it in two later versions.
To save the space of the disinterested :-) the gory details are at
<http://webtuitive.com/samples/sql-prob.html>
TIA!
--
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.