Random mysql?

[Perad]

I have this query?

 

$sql = "SELECT * FROM x_poll WHERE category='$poll'";

 

Is there anyway to return one random result without using php rand?

[lordfrikk]

<?php
$sql = "select * from x_poll where category = '$poll' order by rand() limit 1";
?>/code]