[thelist] MySQL: SELECT DISTINCT ... ORDER BY RAND() bug?

[Jay Blanchard]

[snip]
Anyone had a problem with combining

    SELECT DISTINCT  ....  ORDER BY RAND()

[/snip]

I don't have another database (other than MySQL) handy, but I do have
3.23.33, 3.23.47, 3.23.49, 4.0.13 and I tested the above query on all
and got not problems with the results from the command line. What table
type are you using (mine are all ISAM)?