title: Full text search including tags
body: <p>This isn't entirely exclusive to cakephp but that's the framework im using so any help by thateans would be great..!</p>
  
  <p>I have a MySQL table of posts, tags and post_tags to associate the two together.</p>
  
  <p>I've set up my full text fields on my posts table to be the body and title but I wanted to include the associated tags into my searching too and order the posts based on where the search query mathes any of the tags assigned to the posts.</p>
  
  <p>Would I need to build a hefty SQL query for this perhaps? Also if anyone could offer a cakephp specific solution I'd also like to cache the searches too using the inbuilt cache methods...</p>
  
  <p>Many thanks! </p>