I'm using this query:
SELECT GROUP_CONCAT(coluna1) as valores FROM arquivos WHERE coluna2 IN (21, 22)
It returns the values in column1 of rows whose column2 has one of the values specified.
The problem is that in this case, the value 21 is not found in the table. So I need to return a NULL. But the query is only returning the found value.