MAKE_SET(1 | 4,'A','B','C'); : MAKE_SET « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. MAKE_SET
mysql>
mysql>
mysql> SELECT MAKE_SET(1 | 4,'A','B','C');
+-----------------------------+
| MAKE_SET(1 | 4,'A','B','C') |
+-----------------------------+
| A,C                         |
+-----------------------------+
1 row in set (0.02 sec)








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