mysql> select * from test;
+------+------+------+
| a | b | c |
+------+------+------+
| 5 | 6 | 1 |
| 1 | 5 | 6 |
| 6 | 5 | 1 |
| 6 | 1 | 5 |
| 1 | 2 | 3 |
+------+------+------+mysql> select * from test where FIND_IN_SET('5',CONCAT_WS(',',a,b,c)) && FIND_IN_SET('6',CONCAT_WS(',',a,b,c));
+------+------+------+
| a | b | c |
+------+------+------+
| 5 | 6 | 1 |
| 1 | 5 | 6 |
| 6 | 5 | 1 |
| 6 | 1 | 5 |
+------+------+------+
+------+------+------+
| a | b | c |
+------+------+------+
| 5 | 6 | 1 |
| 1 | 5 | 6 |
| 6 | 5 | 1 |
| 6 | 1 | 5 |
| 1 | 2 | 3 |
+------+------+------+mysql> select * from test where FIND_IN_SET('5',CONCAT_WS(',',a,b,c)) && FIND_IN_SET('6',CONCAT_WS(',',a,b,c));
+------+------+------+
| a | b | c |
+------+------+------+
| 5 | 6 | 1 |
| 1 | 5 | 6 |
| 6 | 5 | 1 |
| 6 | 1 | 5 |
+------+------+------+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货