# 仅支持标准格式的逗号分隔字符串例如 "1,2,3"
select concat(",", str, ",") regexp concat(",", replace(strlist,',',',|,'),",");
mysql 两个逗号分隔的字符串取交集
最新推荐文章于 2023-08-03 20:05:18 发布
# 仅支持标准格式的逗号分隔字符串例如 "1,2,3"
select concat(",", str, ",") regexp concat(",", replace(strlist,',',',|,'),",");