Page 1 of 1

problem with RAND function

Posted: Tue May 06, 2003 1:24 pm
by mzfp2
hi the following query runs perfect on my machine which has MYSQL

SELECT * FROM banners ORDER BY RAND() LIMIT 1

however when testing the same query on my host which has MYSQL also, it always returns the same row

are there version differences, or can some hosts prevent the RAND function from being used?

Posted: Tue May 06, 2003 1:31 pm
by twigletmac
It's a MySQL version specific thing, have a read of:
http://www.mysql.com/doc/en/Mathematica ... ml#IDX1273

and the user notes.

Mac

Posted: Tue May 06, 2003 1:36 pm
by mzfp2
It seems my host probably has MYSQL < 3.23 .. so how can the same query be executed on MYSQL version previous to 3.23?