How to get the possible values for SET field in MySQL?

To get possible values for set field, you can use below syntax −

desc yourTableName yourSetColumnName;

Let us first create a table −

mysql> create table DemoTable
   (
   Game set('Chess','Pig Dice','29 Card')
   );
Query OK, 0 rows affected (0.60 sec)

Following is the query to get available values for set field −

mysql> desc DemoTable Game;

This will produce the following output −

+-------+-----------------------------------+------+-----+---------+-------+
| Field | Type                              | Null | Key | Default | Extra |
+-------+-----------------------------------+------+-----+---------+-------+
| Game  | set('Chess','Pig Dice','29 Card') | YES  |     | NULL    |       |
+-------+-----------------------------------+------+-----+---------+-------+
1 row in set (0.02 sec)

Smita Kapse

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• MySQL query to set current date in the datetime field for all the column values
• Set all values in a MySQL field to 0?
• How can I get enum possible values in a MySQL database?
• MySQL query to get the next number in sequence for AUTO_INCREMENT field?
• MySQL query to get the max value with numeric values in varchar field?
• Set ENUM in MySQL for column values
• How to set default Field Value in MySQL?
• MySQL query to set values for NULL occurrence
• How to get MySQL combined field result?
• Display only the default values set for columns in MySQL
• How can I get enum possible values in a MySQL database using PHP?
• Set custom messages for enum values in MySQL
• Set multiple values for custom columns in MySQL?
• Get the duplicate values of a field in MongoDB?
• How to map keys to values for an individual field in a MySQL select query?