In message <6d5c60840711231103q367d7a58lae549e2b0933737d@xxxxxxxxxxxxxx> , Blaine <apelouperdeu@xxxxxxxxx> writes >MySql.. > >SELECT * FROM MyTable ORDER BY RAND() LIMIT 10 > He wanted a random record from the last 10 records, your query will give him 10 records from anywhere in the table. -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
