mysql - Get records from database in interval of 2 seconds -

i have question mysql:

$result = mysql_query("   select *      table order rand() limit 10 

when write script 10 rows fetched in 2-3 second. possible fetch each 1 row 2 second?

the answer no(atleast using plain mysql). when write select statement fetch rows execute it. cannot retrieve interval of 2 seconds.

as alternative can change limit 1 , execute query in interval of 2 second not approach.