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
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