多条数据以一条数据展示:GROUP_CONCAT
select GROUP_CONCAT(uuid) from user;
判断某字符是否存在某字段:INSTR
select * from(
select GROUP_CONCAT(uuid) names from user
) temp where INSTR(uuid,‘001‘);
2022-10-11 09:41:19
多条数据以一条数据展示:GROUP_CONCAT
select GROUP_CONCAT(uuid) from user;
判断某字符是否存在某字段:INSTR
select * from(
select GROUP_CONCAT(uuid) names from user
) temp where INSTR(uuid,‘001‘);