mysqlFIND_IN_SET用法_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:44:28
mysqlFIND_IN_SET用法_MySQL
mysqlFIND_IN_SET用法_MySQL:mysql 中 FIND_IN_SET 是判断某个字符串是否在带逗号的字符串中 例如 SELECT t.group_id, COUNT(group_id) tsum FROM (SELECT group_id FROM xx WHERE FIND_IN_SET(openid,'qqqwqnfocFq5IL2sXB2Qu0I,oa
导读mysqlFIND_IN_SET用法_MySQL:mysql 中 FIND_IN_SET 是判断某个字符串是否在带逗号的字符串中 例如 SELECT t.group_id, COUNT(group_id) tsum FROM (SELECT group_id FROM xx WHERE FIND_IN_SET(openid,'qqqwqnfocFq5IL2sXB2Qu0I,oa
mysql 中 FIND_IN_SET 是判断某个字符串是否在带逗号的字符串中
例如
SELECT
t.group_id,
COUNT(group_id) tsum
FROM (SELECT
group_id
FROM xx
WHERE FIND_IN_SET(openid,'qqqwqnfocFq5IL2sXB2Qu0I,oarwerrr-2KRah_TklJEomljhlKg,oaSiouEgtr5t5utLFU8-evmkn5BwQ3_c')
AND user_uuid = 'xxxxxxxxxxxx') t
GROUP BY group_id;
这样就能找出相匹配的数据
后者是带逗号的字符
mysqlFIND_IN_SET用法_MySQL
mysqlFIND_IN_SET用法_MySQL:mysql 中 FIND_IN_SET 是判断某个字符串是否在带逗号的字符串中 例如 SELECT t.group_id, COUNT(group_id) tsum FROM (SELECT group_id FROM xx WHERE FIND_IN_SET(openid,'qqqwqnfocFq5IL2sXB2Qu0I,oa
