Great!Didn't know you could do that. Cheers Terry
----------Original Message--------- > I think I found another answer to my own question. FYI a good way to > return > results in a random order > SELECT user FROM table ORDER BY RAND() > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]