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






  1. MySQL Tutorial
  2. String Functions
  3. MAKE_SET
mysql>
mysql> SELECT MAKE_SET(1 | 4,'A','B',NULL,'C');
+----------------------------------+
| MAKE_SET(1 | 4,'A','B',NULL,'C') |
+----------------------------------+
| A                                |
+----------------------------------+
1 row in set (0.00 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