Simplifying MySql queries

Hi all, I'm using in my PHP script the following four MySql queries: $q1=mysql_query("SELECT * FROM CandidateQuestions WHERE Category='1' ORDER BY RAND() LIMIT 1"); $q2=mysql_query("SELECT * FROM CandidateQuestions WHERE Category='2' ORDER BY RAND() LIMIT 1"); $q3=mysql_query("SELECT * FROM CandidateQuestions WHERE Category='3' ORDER BY RAND() LIMIT 1"); $q4=mysql_query("SELECT * FROM CandidateQuestions WHERE Category='4' ORDER BY RAND() LIMIT 1"); and here goes the question: is there a way to make these four in one so strictly one random question is selected from all of the four categories? Thanks! -- With best regards from Ukraine, Andre Skype: Francophile Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion