If I say: SELECT * FROM tablename ORDER BY rand() LIMIT 50
Will that give me the first 50 records from the table and randomize their order, or will it give me 50 records randomly from throughout the entire table?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]