mysql 统计单词,MySQL +计算列中的所有单词

I have 2 columns in a table and I would like to 'ruffly' report on the total number of words.

Is it possible to run a MySQL query and find out the total number of words down a column.

It would basically be any text separated by a space or multiple space.

Doesn't need to be 100% accurate as its just a general guide.

Possible?

thx

解决方案

Try something like this:

SELECT COUNT(LENGTH(column) - LENGTH(REPLACE(column, ' ', '')) + 1)

FROM table

This will count the number of caracters in your column, and substracts the number of caracters in your column removing all the spaces. Hereby you know how many spaces you have in your row and hereby know how many words there are (roughly because you can also type in a double space, this wil count as two words but you say you want it ruffly so this should suffice).