title: MONTHNAME in Portuguese MYSQL
body: <p>I´ve got a huge query (In a PHP file) that gives me a monthname from some dates:</p>
  
  <pre><code>CASE A.STATUS
  WHEN 'Cancel' THEN LEFT(MONTHNAME(DT_CANCEL),3)
  WHEN 'About to cancel' THEN LEFT(MONTHNAME(DATA_REGISTER),3)
  
  END AS MONTH_CANCEL,
  </code></pre>
  
  <p>Is there a way to insert my language inline with MONTHANAME?</p>
  
  <p>Something like: </p>
  
  <pre><code>WHEN 'Cancel' THEN SET LANGUAGE Portuguese LEFT(MONTHNAME(DT_CANCEL),3)
  </code></pre>
  
  <p>I don´t want to write case for eveymonth to transform 'Dec' to 'Dez' and so on, this will take too long.</p>