Is it possible to find the repeating patterns in the TEXT stored in MySQL?

Is it possible to find repeating patterns in the text?

My table looks like this:

CREATE TABLE `textanalysis` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    开发者_高级运维`abstract` text,
    UNIQUE KEY `ID` (`ID`),
    FULLTEXT KEY `abstract` (`abstract`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

I would like to find the words or group of words in the text then make a statistics.

---

Here is some tricks (not very optimized)

use "apple" for example,
length for apple is 5

SELECT
  (LENGTH(abstract)-LENGTH(REPLACE(LOWER(abstract), 'apple', '')))/5 
  AS occurrences
FROM
  textanalysis
WHERE
  MATCH (abstract) AGAINST ('+apple' IN BOOLEAN MODE);

What is does is to replace apple (make the length of abstract shorter),
and you compare the original length to deduce number of occurrences.

---

I'm not so clear about your requirement, but if you want to count the occurrence of each distinct words, you can try

select count(id) as total_word, abstract from textanalysis group by abstract;