title: MySQL Formatting YEARWEEK(date)
body: <p>I am having trouble formatting SQL output of YEARWEEK(date_created) function.</p>
  <p>I would like to format it as: <strong>week04, December</strong> or something similar with human being able easily to process.</p>
  <p>Here's data which is being returned as:</p>
  <pre><code>SELECT 
      DATE(date_created) as date_,
      YEARWEEK(date_created) as week_
  ...
  </code></pre>
  <p>Result Set:</p>
  <blockquote>
  <p>date_   ---------------------------------------- week_</p>
  <p>2017-12-30    -------------------------------- 201752</p>
  <p>2018-01-06    -------------------------------- 201753</p>
  <p>2018-01-10    -------------------------------- 201801</p>
  </blockquote>
  <p>Why is 2018-01-06 (January the 6th of 2018) considered as 53th week of 2017?</p>