统计一个字段中出现 ( 多个指定词) 的出现的次数

最新推荐文章于 2025-12-17 14:04:46 发布

转载最新推荐文章于 2025-12-17 14:04:46 发布 · 1k 阅读

文章标签：

#ruby

网站建设专栏收录该内容

740 篇文章

订阅专栏

本文通过具体的Ruby代码示例展示了如何使用MySQL进行复杂的统计查询，包括利用LOCATE和CONCAT函数来统计包含特定字符串的记录数量。

Ruby代码
mysql>select sum(if(locate(',watch,',concat(",",seokeyword,","))>0,1,0)) as watch,sum(if(locate(',fashion watch,',concat(',',seokeyword,',')>0,1,0)) as `fashion watch`
from uxcell_channels;

+-------+---------------+
| watch | fashion watch |
+-------+---------------+
|   928 |           501 |
+-------+---------------+

mysql>select sum(if(locate(',watch,',concat(",",seokeyword,","))>0,1,0)) as watch,sum(if(locate(',fashion watch,',concat(',',seokeyword,',')>0,1,0)) as `fashion watch`
from uxcell_channels;

+-------+---------------+
| watch | fashion watch |
+-------+---------------+
|   928 |           501 |
+-------+---------------+

Ruby代码
ux.first.attributes
ux.first.attributes.keys