title: How to order mysql query results by random() and by another field?
body: <p>I have the following query which sorts results randomly:</p>
  
  <pre><code>$sql = "SELECT *, `active` FROM `profiles` WHERE CONCAT(',' , pfCategory , ',') LIKE '%$category%' AND `active`='1' ORDER BY RAND()";
  </code></pre>
  
  <p>I would like to add a boolean field in <code>profiles</code> table so the random results with value 1 will appear on top of those with value 0 in the random list. Is that possible? Thanks  </p>