EXPORT_SET() FUNCTION in MySQL

by

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