Question: I'm looking to get a random row from MySQL without using too much time or resources on the system. I don't care about weather the code given is PHP or MySQL based, **however please note there are 'gaps' in my table.**

My table columns are
'id' (Primary key, auto increment), varchar, int, int

I'd like it to be as random as possible

Answer: 
The good solution was in [What is the best way to pick a random row from a table in MySQL?](https://stackoverflow.com/questions/142242/what-is-the-best-way-to-pick-a-random-row-from-a-table-in-mysql) question.
You can use:

```
SELECT id FROM table ORDER BY RAND() limit 1

```