On Fri, Feb 28, 2003 at 05:19:15PM +1100, Justin French wrote: > Hi all, > > On my LAN server (FreeBSD, MySQL 3.32) the following query works fine, and > seems to return 2 random rows from the table: > > SELECT * FROM disc ORDER BY RAND() LIMIT 2 > > However, when I upload the scripts to the live server (Linux, MySQL 3.32), > the results are VERY un-random -- only very occasionally do the results > differ between each query, usually returning the same two rows. > > The data in the two tables isn't identical, but both tables DO contain the > same number of rows, with the same IDs. > > > Where should I be looking for reasons why the RAND() isn't very random???
Consider upgrading - the problem should be fixed in the most recent versions of 3.23.x and 4.0.x Cheers! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Support Global Human Rights - Amnesty International (http://amnesty.org) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php