title: MySQL Full text boolean search with tags
body: <p>I've never done searching from MYSQL before, but I need to implement a search. I have three tables: <code>articles</code>, <code>articles_tags</code>, and <code>tags</code>.</p>
  
  <p>The table <code>articles</code> holds the first thing I would like to search on, the <code>title</code> field. </p>
  
  <p>The table <code>articles_tags</code> is a pivot table which relates <code>articles</code> and <code>tags</code> together. <code>articles_tags</code> has two fields, that are: <code>articles_id</code> and <code>tag_id</code>.</p>
  
  <p>And, the table <code>tags</code> holds the second thing I would like to search on, the <code>name</code> field.</p>
  
  <p>My problem is, I need a way to search the <code>title</code> field, and each of the tags that relate to that article (<code>tags.name</code>) and return a relevancy (or sort by relevancy) for the specific article.</p>
  
  <p>What would be a good way to implement this? I'm pretty sure it can't be done from just one query so two queries, and then <code>mixing</code> the relevancies together, would be ok.</p>
  
  <p>Thanks.</p>
  
  <p><strong>Edit:</strong> Forgot to say, if I could give more weighting to matching a tag than matching a word in the title, that would be awesome. I'm not really asking for anyone to write the thing, but give me some direction. I'm a bit of a newbie in both PHP and MySQL.</p>