页次: 1
set 类型的的基本介绍可以看 mysql 中的set 例子,示例
首先创建一个表
mysql> create table tb_set( s set('a', 'b', 'c')); Query OK, 0 rows affected (0.27 sec) mysql> insert into tb_set values ('a'), ('b'), ('a,b'), ('c'), ('c,a'), ('c,b'), ('c,a,b'); Query OK, 7 rows affected (0.11 sec) Records: 7 Duplicates: 0 Warnings: 0 mysql> select * from tb_set; +-------+ | s | +-------+ | a | | b | | a,b | | c | | a,c | | b,c | | a,b,c | +-------+ 7 rows in set (0.00 sec)
第一个查询, 如果查询所有包含元素 a 的行
mysql> select * from tb_set where s&1;
+-------+
| s |
+-------+
| a |
| a,b |
| a,c |
| a,b,c |
+-------+
4 rows in set (0.00 sec)
第二查询, 查询包含 a 和 b 的元素
mysql> select * from tb_set where s&1 and s&2; +-------+ | s | +-------+ | a,b | | a,b,c | +-------+ 2 rows in set (0.00 sec)
ipbbs.net
离线
页次: 1