EXPORT_SET() FUNCTION in MySQL

EXPORT_SET() FUNCTION
The MySQL EXPORT_SET function is used to get a string for each bit set.

Syntax:

EXPORT_SET( bits, on, off, separator, number_of_bits )

Example:

mysql> SELECT EXPORT_SET ( 5, ‘a’, ‘b’, ‘,’, 4 );

Output:

a,b,a,b