Return 1 Random Row

[NZ_Kiwis]

I have a mysql database and I want I want to return 1 single random row.

My only other condition is WHERE CatID = 5 so I want something like

SELECT RANDOM(1) FROM MYTABLE WHERE CatID = 5 

How can I do this using mysqli?

Can I select all and put it into an array and select a random array item?

[NogDog]

You might want to check out this discussion in the Database sub-forum: http://board.phpbuilder.com/showthread.php?10338930-Fast-Random-Results-quot-ORDER-BY-RAND%28%29-quot-is-bad