SELECT * FROM (
SELECT ID,GROUP_CONCAT(A2,A1) TEXT
from datatable1 GROUP BY ID
) AS A
WHERE A.TEXT LIKE '%1%' AND ID = A.ID
SQL 字符串拼接函数
最新推荐文章于 2024-05-30 15:06:25 发布
SELECT * FROM (
SELECT ID,GROUP_CONCAT(A2,A1) TEXT
from datatable1 GROUP BY ID
) AS A
WHERE A.TEXT LIKE '%1%' AND ID = A.ID