title: Text Search across multiple fields MySQL
body: <p>I have a MySQL table laid out like this:</p>
  
  <pre><code>ID | Artist | Title
  </code></pre>
  
  <p>Which contains song information obtained from MP3 ID3 tags.</p>
  
  <p>Now, I would like to be able to run a search on this, however the incoming data could be in a variety of formats. I'm sure you all know how ID3 tags can end up after a couple of people have had hold of them.</p>
  
  <p>I have the following query which I have tried, but looking at it now, I understand completely why it doesnt bring back a result set. I'm fresh out of ideas.</p>
  
  <pre><code>SELECT CONCAT(artist, ' ',title) as trackname 
  FROM sound_tracklist 
  WHERE CONCAT(artist,' ',title) LIKE '%[JunkTags]Artist - Title[More Junk - www.junkwebsite.com]%'
  </code></pre>
  
  <p>I'd appreciate any input/direction on this.</p>
  
  <p>Thanks</p>