MAKE_SET() FUNCTION in MySQL

MAKE_SET() FUNCTION The MySQL MAKE_SET function is used to get values from the set for the given bit.

Syntax:

MAKE_SET (bits, string_1, string_2, … string_n );

Parameters: bits: It is used to specify the bits to return. string_1, string_2, … string_n: It is used to specify a list of strings.

Example:

mysql> SELECT MAKE_SET (1, ‘a’, ‘b’, ‘c’, ‘d’ );

Output:

‘a’
Please follow and like us:
Content Protection by DMCA.com