title: Convert HEX column to DEC in MySQL
body: <p>I am writing an application which will do some formatting to CSV file and uploads the table to mysql after that the program should convert a (hex) column to decimal one</p>
  
  <p>The table looks like this:</p>
  
  <p>col1 | col2 | hexcol | deccol</p>
  
  <p>So i need to take hexcol and convert from hex2dec and put it into deccol</p>
  
  <p>I tried simple <strong>SELECT UNHEX('hexcol');</strong>   but it won`t work it says this colum is not in the field list ... </p>
  
  <p>Any help would be appreciated ...</p>