title: PHP + MySQL - script for search (fulltext)?
body: <p>I would like to ask for help with this task:
  I have a MySQL table with structure like this:</p>
  
  <pre><code>author                name        year       description
  Bernard Cornwell      Azincourt   2009       Publisher XY, good condition
  </code></pre>
  
  <p>Now I would like to have MySQL Query which returns result (searches the book) on various inputs (like these):</p>
  
  <ul>
  <li>Cornwell</li>
  <li>Azincourt</li>
  <li>Cornwell Azincourt </li>
  <li>Azincourt Cornwell</li>
  <li>Cornwell Azincourt 2009</li>
  <li>Bernard Cornwell Azincourt</li>
  <li>Azincourt</li>
  </ul>
  
  <p>Do I have to add Fulltext index on every column and then on author, name, year, description?</p>