title: Sorting results by 'most relevent' - MYSQL & PHP
body: <p>I've never really considered this question before and wondered if anyone has any advice or input on best practices for achieving 'relevent results'.</p>
  
  <p>In my case I'm running a search query that includes full text searching across 5 fields, a geographic radial lookup and a number of basic comparisons.</p>
  
  <p>I can prioritise the fields I'm most interested in for this example..</p>
  
  <p>In looking for keyword X </p>
  
  <ul>
  <li>Filter results by geographic lookup.</li>
  <li>If keyword found in "basic comparisons" then these results should come first.</li>
  <li>Then follow with results if keyword found in "full keyword search".</li>
  </ul>
  
  <p>Would the best route be to take the PHP result array, turn this into an object and then compare and sort before displaying?</p>