php - Problem with Sql conditional statement

Question

A sql statement has an employee id field after group by and is put together through the group concat function. Now the business requires finding the result where the employee id is a, then the employee field must be filtered out whether it only has a or contains a. This How to write it?

仅有的幸福 · Answer

It is recommended that you briefly list the attributes of the table, otherwise the description will not be clear.
group concat is just grouping, what really plays a filtering role is the where condition

PHP中文网 · Answer

select * from table where id like '%a%'

迷茫 · Answer

Use subquery, wrap it one layer and add where condition