title: MySQL Search (Sort by Relevance)
body: <p>Can any one help me how to sort rows by relevance for the following criterion ?</p>
  
  <pre><code>`tbluser`
  - - - - - - -
  First Name
  Last Name
  
  `tbleduc`
  - - - - - - -
  School
  College
  University
  </code></pre>
  
  <p>On the search form the user has following fields</p>
  
  <pre><code>Name
  School
  College
  University
  </code></pre>
  
  <p>Where School College and University are Optional..</p>
  
  <p>And Name is split into 2 words (other words in middle are omitted), first word is taken as first anme and last word as last name..</p>
  
  <p>Now I would like to implement search based on relevance. </p>
  
  <p>Thanks for the help :)</p>