Select random value from MySQL database table.

The simplest way of selecting random rows from the MySQL database is to use “ORDER BY RAND()” clause in the query.
Solution 1 [SQL QUERY]
SELECT * FROM `table` ORDER BY RAND() LIMIT 0,4;
This query select 4 random value every refresh?
The problem with this method is that it is very slow. The reason for it being so [...]

Read Full Post »