统计字段出现次数
1.
SELECT
SUM(IF(LOCATE(keyword, t.field) > 0, 1, 0)) AS `AppearTimes`
FROM t
WHERE CONDITION
2.
SELECT
SUM(CASE t.field WHEN keyword THEN 1 ELSE 0 END) AS `AppearTimes`
FROM t
WHERE CONDITION
统计字段出现次数
1.
SELECT
SUM(IF(LOCATE(keyword, t.field) > 0, 1, 0)) AS `AppearTimes`
FROM t
WHERE CONDITION
2.
SELECT
SUM(CASE t.field WHEN keyword THEN 1 ELSE 0 END) AS `AppearTimes`
FROM t
WHERE CONDITION