title: Outputting mac address as standard format in mysql
body: <p>After reading some research, I understand that mac addresses stored in mysql should be stored as <code>BIG INT</code>.  Is there an easy way to output the mac's in the standard hex form:  <code>ab:23:a4:23:54:33</code> when using a <code>SELECT</code> statement?</p>
  
  <p>I know I can use <code>hex()</code> to convert format to hexadecimal, but i'd like the full 6 bytes and colons.  thanks.</p>
  
  <p>Something like:  </p>
  
  <p><code>SELECT hex(macAddress) from &lt;table&gt;;</code></p>