| | | 23.27.1.MAKE_SET(bits,str1,str2,...): Returns a string containing substrings separated by ',' characters |
|
|
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 |
|