title: Select Statement With An Update
body: <p>I am creating a site that displays articles. The article table has the following fields:</p>
  
  <pre><code>article_id
  title
  text
  views
  </code></pre>
  
  <p>ATM I am selecting the the article and outputting it but I would like to also <strong>increment the views in the same query</strong> ie "views=views+1".</p>
  
  <p>The query would look like this</p>
  
  <pre><code>SELECT article_id, title, text, views
  SET views=views+1
  WHERE article_id=:article_id
  </code></pre>
  
  <p>I want to get the incremented result of views as well in the output so I am guessing I would need place the SET before the SELECT.</p>