I have a table with one column of data type 'SET'. It's easy enough to extract the settings in this column from any row. But I want to be able to compare those settings to the full list contained in the table structure.
I need first to extract this full list of 'SET' options from the table structure.
I have tried 'mysql_field_type' but it doesn't yield enough detail (I just get told it's a binary string of a certain length).
I recognise that the 'SET' data type has many limitations, and perhaps this is one of them, but if anyone knows how to do this, I'd be grateful.
I could type the full list into my PHP code as an array, but then I'd have to edit it if I changed the DB table, so I'm trying to avoid that.