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;
这样就能找出相匹配的数据
后者是带逗号的字符
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
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