[eluser]nuwanda[/eluser]
[quote author="JanDoToDo" date="1264403700"]I believe you can use the INFORMATION SCHEMA, i.e.
SELECT COLUMN_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'YourDatabase'
AND TABLE_NAME = 'YourTable'
AND COLUMN_NAME = 'YourEnum'
COLUMN_TYPE
-----------------
enum('A','B','C','D')[/quote]
Thanks, but exactly how do I extract the enum as discrete values?
I'm doing this...
Code:
$qstring="SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'bst_ci_db' AND TABLE_NAME = 'users' AND COLUMN_NAME = 'user_role'";
$query = $this->db->query($qstring);
echo '<pre>';
print_r($query->row());
echo '</pre>';
}
and getting this:
Code:
stdClass Object
(
[COLUMN_TYPE] => enum('member','admin')
)
Man, I feel thick.