I am trying to get all possible values for an enum field (mysql). Here's the query:
SHOW COLUMNS FROM tbl_name LIKE field_name
which returns a string
enum('yes','no')
I am trying to do a regex match to extract the values yes,no from the string.
I've had no luck. I've looked through various online docs and nothing that seems to address my specific problem of extracting items from (). I may have missed something somewhere.
thanks in advance,
- Keith