title: Mysql convert an int to MAC
body: <p>I have some data that converts which has a 2 columns one column has IP and it contains values which are integers.I used the following function in my mysql query.Is there a function i can use to to convert my mac column which contains integers and data type is bigint to MAC address.</p>
  
  <pre><code>SELECT  INET_NTOA(ip_address) AS myip,mymac 
  FROM table1
  </code></pre>