title: MySQL Search Algorithm
body: <p>I somewhere read earlier about this, and failed to find it this time.</p>
  
  <p>I have a table with 4 columns as follows:</p>
  
  <pre><code>+----+------+-------+-------------+
  | id | Name | Title | Description |
  +----+------+-------+-------------+
  </code></pre>
  
  <p>Now I read that we can combine the Name, Title and Description in such a way that you can search later on and output will be sorted based on the text repeat.</p>
  
  <p>For eg: If I search for "Who is James"</p>
  
  <p>It will search for it in Name, Title and Description and will return the rows based on Existence of this string Partially or fully within the columns.</p>
  
  <p>Please help!!!</p>