String Functions MySQL Tutorial

Set in the value bits by on string and off string.
Separated is set by the separator string.
The default is the comma character ','.
The number of bits is set by number_of_bits.
number_of_bits defaults to 64.

mysql>
mysql> SELECT EXPORT_SET(5,'Y','N',',',4);
+-----------------------------+
| EXPORT_SET(5,'Y','N',',',4) |
+-----------------------------+
| Y,N,Y,N                     |
+-----------------------------+
1 row in set (0.00 sec)
mysql>