如何计算MySQL Blob文本中特定单词出现的次数? [英] How to count the number of occurrences of a particular word in a MySQL blob text?

问题描述

我已将文本文件的内容作为Blob存储在MySQL表中.我想计算该文本中某个特定单词出现的次数.

I have stored the contents of a text file in a MySQL table as a blob. I want to count the number of occurrences of a particular word from that text.

有什么办法可以做到吗?

Is there any way I can do that?

推荐答案

尝试一下

SET @searchthis="lumia"; 
SELECT  CAST((LENGTH(`documents`.`file`) - 
              LENGTH(REPLACE(`documents`.`file`, @searchthis, ""))) /
              LENGTH(@searchthis) AS UNSIGNED
            ) AS searchthis_count
    FROM  documents ;

这篇关于如何计算MySQL Blob文本中特定单词出现的次数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！