mysql export_set() 函数

 Mysql 字符串函数

export_set()是MySQL的一个Sring函数。此方法为每个位集返回字符串。

语法

select export_set(bits,on,off[,separator[,number_of_bits]]); 

示例 1

select export_set(5, 'Yes','No',',',4);  

输出:

mysql> select export_set(5, 'Yes','No',',',4);
+---------------------------------+
| export_set(5, 'Yes','No',',',4) |
+---------------------------------+
| Yes,No,Yes,No                   |
+---------------------------------+
1 row in set (0.00 sec)

示例 2

select export_set(5, 'hello','bye',',',4); 

输出:

mysql> select export_set(5, 'hello','bye',',',4);
+------------------------------------+
| export_set(5, 'hello','bye',',',4) |
+------------------------------------+
| hello,bye,hello,bye                |
+------------------------------------+
1 row in set (0.00 sec)