Select a random row in MySQL

Written by Mfawa Alfred Onen on . Posted in MySQL, PHP

I know this topic is not a new one and I was playing with the solutions out there but most of them just don’t scale for me until I found this interesting was of doing it. It actually involves a three (3) query step process which you can checkout in the PHP script below. I have also attached a zip version of the script.