title: MySQL return all column names in uppercase
body: <p>I have SQL query, just to simplify it, imagine having columns <code>id</code>, <code>name</code>, <code>pass</code> in table users and I want database to return these column names in uppercase like ID,NAME,PASS. I know that i can A) rename columns in database B) select it in uppercase like
  <code>SELECT ID,NAME,PASS FROM users</code> ... But I need to use it like this: <code>SELECT * FROM users</code>. I tried to use something like <code>SELECT UPPER(*) FROM users</code>, but it gives me syntax error.</p>
  
  <p>To clarify: I need column <strong>names</strong> in uppercase, not column values!</p>
  
  <p><strong>MY SOLUTION:</strong><br>
  So after many tries I have done it through PHP after fetching results. Guess It's easier, so I called function    <a href="http://php.net/manual/en/function.array-change-key-case.php" rel="nofollow">array_change_key_case</a>    which returns keys of array in satisfied key case (obviously keys of this array were also column names)     </p>