Hi Jay, There seemed to be a problem with the first use of RAND() on new connections (is this in a script?). It was supposed to be fixed in a recent version of MySQL (I think in 3.23.56 and 4.0.10). Anyway, the workaround I discovered to work is to just call RAND() at least once before using it in your random query. e.g. just run a query like this first:
SELECT RAND(), RAND(), RAND(); BTW, what version of MySQL are you using? Try running your query multiple times from the command line and it will probably work correctly after the first time. So either upgrade MySQL or use my above workaround. :-) Hope that helps. Matt ----- Original Message ----- From: "Jay Paulson" Sent: Thursday, August 28, 2003 2:57 PM Subject: Random Selects Hello- I'm trying to get random information out of my table and the query I'm using keeps returning the same row every time. In the table I have 3 rows and I want to choose at random in the sql which row to return. Here's an example query I have. SELECT * FROM banner ORDER BY rand() asc limit 0,1 This returns the first row in the table every time. What's strange is that I have a query for a table that has about 500 rows in it and it works fine with the exact same syntex (except the the table is different). Is there anything I'm doing wrong? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
