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?
problem with RAND function
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
http://www.mysql.com/doc/en/Mathematica ... ml#IDX1273
and the user notes.
Mac