rshadarack Posted September 28, 2006 Share Posted September 28, 2006 I have a set column in a table in mysql. I wish to get a list (preferably some sort of array, but I could parse a list of text as well) of possible entries for that set. What is the query to do so? Link to comment https://forums.phpfreaks.com/topic/22326-mysql-get-possible-set-values/ Share on other sites More sharing options...
AndyB Posted September 28, 2006 Share Posted September 28, 2006 [code]$query = "SELECT column_name from table_name";$result = mysql_query($query);....[/code] Link to comment https://forums.phpfreaks.com/topic/22326-mysql-get-possible-set-values/#findComment-100008 Share on other sites More sharing options...
fenway Posted September 28, 2006 Share Posted September 28, 2006 To be honest, I've never used that column type, but I assume it comes back comma-separated? Link to comment https://forums.phpfreaks.com/topic/22326-mysql-get-possible-set-values/#findComment-100286 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.