title: Understanding a MySQL query
body: <p>I've been seeing queries like the one below more commonly now than ever. What I'm lost at is 'p.title', the 'as' clause, and 'FROM Posts p'. Anybody care to explain these parts to me or refer me to resources as I have no clue what to search for in Google?</p>
  
  <pre><code>SELECT p.title, SUBSTR(p.post,1,300) as post 
  FROM Posts p 
  WHERE p.title LIKE '%{$q}%' 
    OR p.post LIKE '%{$q}%'");
  </code></pre>