MAKE_SET Function
MAKE_SET:
This function return the substring (separated by ‘,’) in the position given in first argument as bit.NULL values are not appended to the result.
Syntax:
MAKE_SET(bits,str1,str2,…)
Example:
SELECT MAKE_SET(3,’term’,'definition’,'treatment’);
Output:
term,definition
(3 means that (11 in binary). So it gives first 2 strings.”term,definition”)
