title: Most efficient way to search in SQL?
body: <p>I have a database with 75,000+ rows with 500+ entries added per day.</p>
  
  <p>Each row has a title and description.</p>
  
  <p>I created an RSS feed which gives you the latest entries for a specific search term (ex. <a href="http://site.com/rss.rss?q=Pizza">http://site.com/rss.rss?q=Pizza</a> would output an RSS for the search term "Pizza").</p>
  
  <p>I was wondering what would be the best way to write the SQL query for this. Right now I have:</p>
  
  <pre><code>SELECT * 
  FROM 'table' 
  WHERE (('title' LIKE %searcherm%) OR ('description' LIKE %searcherm%))
  LIMIT 20;
  </code></pre>
  
  <p>But the problem is it takes between 2 to 10 seconds to execute the query.</p>
  
  <p>Is there a better way to write the query, do I have to cache the results (and how would I do  that?) or would changing something in the database structure speed up the query (indexes?)</p>