STAT. Fields appear times

统计字段出现次数

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