[MySQL][Highload] Random row from big query result
Hi all, I need to get 1-2 rows from query result retrived with SQL select on indexed columns without getting the whole record set. For example I will retrieve 10 000 records using query SELECT * FROM table WHERE field 1>1 AND field1 < 10 but I need only 1 random row from this query regarding to highload of my database. I can use ...