How can I fetch 10 random values from 50k rows fastly

Question

How can I fetch 10 random values from 50k rows fastly including Inner Joins Please Reply asap.... Thanks in advance

Vinod Sharma · Answer

But I Have 4 Tables inter related by product table and i have to fetch random 10 rows from product table using inner join with other tables...my select query taking long time to execute on server i have to show products fast....tell me any example of sql query to fetch fast data from multiple rows......

Munesh Sharma · Answer

SELECT name FROM random AS r1 JOIN ( SELECT ( RAND () * ( SELECT MAX ( id ) FROM random )) AS id ) AS r2 WHERE r1 . id >= r2 . id ORDER BY r1 . id ASC LIMIT 1 or go on this link http://jan.kneschke.de/projects/mysql/order-by-rand/