problem with RAND function
Posted: Tue May 06, 2003 1:24 pm
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?
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?