I'm a newbie to MySQLi and have searched the internet for almost two weeks but cannot find any best result.
Is there any good way to select random records from database using mysqli better than ORDER BY RAND() function?
I heard this function takes times to process just to pick out five from a million records in the database.
Or else, should I use a traditional MySQL way instead of this.
Thanks in advance