title: Order by relevance using boolean fulltext search + rand() for specific column
body: <p>I am using MYSQL MYISAM and php version 5.4.16 and am doing a fulltext search based on the (product_name) column and i want to randomize the result but the problem is rand()not giving the random values.</p>
  
  <p>I tried something like this:</p>
  
  <pre><code>SELECT `product_name`,`main_cat_id`,`sub_cat_id`,`prod_cat_id`,`prod_short_desc`,`com_id`,`product_id`,product_ratings, `min_order_quantity`, `fob`,`country_id`,`company_name`,`attributes`,`attr_values`,`verify`,`image`,product_additionals , MATCH (`product_name`)AGAINST ('"girls top"'IN BOOLEAN MODE) AS relevance, MATCH (`product_name`)AGAINST ('girl* +top*'IN BOOLEAN MODE) AS relevance1 FROM pep_browse_com_prods WHERE (MATCH (`product_name`) AGAINST ('"girls top"'IN BOOLEAN MODE) OR MATCH (`product_name`) AGAINST ('girl* +top*'IN BOOLEAN MODE)) AND STATUS = '0' AND display = '0' ORDER BY relevance DESC,relevance1 DESC,RAND() limit 20
  </code></pre>
  
  <p>I want to set the relevance first then i want the random values of rest columns.</p>