title: MySQL alias for SELECT * columns
body: <p>I'm creating a view that is using data that comes from the same table twice. As a result, same column names appear twice.</p>
  
  <p>Thus, i need to give aliases to these columns. If i were to do it, i'd write it as:</p>
  
  <pre><code>SELECT u.* as 'one_*', u2.* as 'two_*'
  FROM users u
  LEFT JOIN relationships r ON u.id=r.id_one
  LEFT JOIN users u2 ON r.id_two=u2.id
  </code></pre>
  
  <p>But that doesn't work. Thanks for your help!</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Here's the data i'm actually getting:</p>
  
  <pre><code>|  id  | name |  id  | name |
     1     john    2     alex
  </code></pre>
  
  <p>Here's the data i'd like to get (while still using a <code>SELECT u.*, u2.*</code>):</p>
  
  <pre><code>|  id  | name |  brother_id  | brother_name |
     1     john        2             alex
  </code></pre>