Get ENUM values from a WordPress table field.php

<?php

// This will break if the ENUM values have comma (,) in them

function get_enum_values($wpdb, $table, $field) {

  $values = array();
  $table = "{$wpdb->prefix}{$table}";
  $query = "SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'";
  $results = $wpdb->get_results($query, ARRAY_A);

  if (is_array($results) && count($results) > 0) {

    preg_match("/^enum\(\'(.*)\'\)$/", $results[0]['Type'], $matches);

    if (is_array($matches) && isset($matches[1])) {

      $values = explode("','", $matches[1]);

    }

  }

  return $values;

}