查询计数字SQLite 3

本文介绍了查询计数字SQLite 3的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

有没有办法计算文本字符串中的单词？

Is there a way to count words in a text string?

我使用SQLite 3，我试图写一个查询，

I'm using SQLite 3 and I'm trying to write a query that takes a bunch of long strings of text, and counts the number of words in each one.

我也想忽略html标签（或插入符号之间的任何东西），例如段落标签，断开标签，等等。

I also want to ignore html tags (or anything between carets) such as paragraph tags, break tags, etc.

所以当我运行查询从相应的列中选择文本，我得到一个大的冗长的文本输出与一些html标签，我只想要

So when I run a query selecting text from the appropriate column, I get a large wordy text output with some html tags in it, and I just want to count the words.

如何写一个查询来做这个？

How can I write a query to do this?

推荐答案

据我所知，没有办法直接计算SQL lite 3中字符串中的字数。（我更熟悉mysql和ms sql）

As far as I know there is no way to directly count the number of words in a string in SQL lite 3. (I'm more familiar with mysql and ms sql)

您可以使用长度和替换作为工作

You can use Length and Replace as a work around

SELECT length(@String) - length(replace(@String, ' ', '')) + 1