title: phalcon get enum values
body: <p>I'm working with database with a lot of columns with 'enum' and 'set' type. My point is to get values of column in Phalcon controller. I found some snippets, but nothing in Phalcon and when I tried to execute them it seems that Phalcon have some problems.</p>
  
  <pre><code>public function getEnumValues(){
      $sql  = "SHOW COLUMNS FROM profiles LIKE 'eyes_color'";
  
      $query = new \Phalcon\Mvc\Model\Query($sql, $this-&gt;getDI());
      $result = $query-&gt;execute();
  
      return $result;
  }
  </code></pre>
  
  <p>Returns:</p>
  
  <blockquote>
    <p>Syntax error, unexpected token IDENTIFIER(SHOW), near to ' COLUMNS FROM profiles LIKE 'eyes_color'', when parsing: SHOW COLUMNS FROM profiles LIKE 'eyes_color'</p>
  </blockquote>
  
  <p>Approach 2:</p>
  
  <pre><code>public function getEnumValues(){
      $sql = "SELECT COLUMN_TYPE FROM COLUMNS WHERE TABLE_NAME = 'profiles' AND COLUMN_NAME = 'hair_color'";
  
      $query = new \Phalcon\Mvc\Model\Query($sql, $this-&gt;getDI());
      $result = $query-&gt;execute();
  
      return $result;
  }
  </code></pre>
  
  <p>Returns:</p>
  
  <blockquote>
    <p>Model 'COLUMNS' could not be loaded</p>
  </blockquote>
  
  <p>I would be grateful for any help.</p>