title: Best efficient way to make a fulltext search in MySQL
body: <p>I have 3 tables, and I want to make a query for a search term textbox. My query currently looks something like this:</p>
  
  <pre><code>SELECT Artist.* FROM Artist, Band, Instrument WHERE MATCH (Artist.name) AGAINST ('mysearchterm') OR MATCH (Band.name) AGAINST ('mysearchterm') OR MATCH (Instrument.name, Instrument.description) AGAINST ('mysearchterm');
  </code></pre>
  
  <p>This query is taking too much time to get executed. Is there any way to improve this? Am I doing something wrong?</p>
  
  <p>Thanks</p>