MAKE_SET(bits,str1,str2,...): Returns a string containing substrings separated by ',' characters : MAKE_SET « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. MAKE_SET

str1 corresponds to bit 0, str2 to bit 1, and so on.

NULL values in str1, str2, ... are not appended to the result.

mysql>
mysql> SELECT MAKE_SET(1,'a','b','c');
+-------------------------+
| MAKE_SET(1,'a','b','c') |
+-------------------------+
| a                       |
+-------------------------+
1 row in set (0.00 sec)

mysql>








23.27.MAKE_SET
23.27.1.MAKE_SET(bits,str1,str2,...): Returns a string containing substrings separated by ',' characters
23.27.2.MAKE_SET(1 | 4,'A','B','C');
23.27.3.MAKE_SET(1 | 4,'A','B',NULL,'C')
23.27.4.MAKE_SET(0,'a','b','c');
23.27.5.Make first name and last name as a set