Get array from ENUM def in MySQL yo x

gistfile1.aw

<?php
// Change the following:
// TABLE_NAME = the name of your table
// COLUMN_NAME = the name of your column with an enum type

$result = mysql_query("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TABLE_NAME' AND COLUMN_NAME = 'COLUMN_NAME'");
if(mysql_num_rows($result) == 1){
	$remove = array('enum(', ')', "'");
	$row = mysql_fetch_assoc($result);
	$array = explode(',', str_replace($remove, '', $row['COLUMN_TYPE']));
}
?>