56,678
社区成员
发帖
与我相关
我的任务
分享
-- 上面写漏一种情况
SELECT
n1
FROM
(SELECT
n1, GROUP_CONCAT(n2) AS 'n2'
FROM
test
GROUP BY n1) a
WHERE
n2 = 'a' OR n2 = 'b' OR n2 = 'a,b' OR n2 = 'b,a';
SELECT
n1
FROM
(SELECT
n1, GROUP_CONCAT(n2) AS 'n2'
FROM
test
GROUP BY n1) a
WHERE
n2 = 'a' OR n2 = 'b' OR n2 = 'a,b';
select id, n1
from test2
where (n2 = 'a' or n2 = 'b') and n1 = 1;
括号打错了。。select id, n1
from test2
where n2 = ('a' or n2 = 'b') and n1 = 1;