KWDA on text column mysql

[ukgimp]

I am after doing some keyphrase analysis on a text column in myql with a view to doing find and replaces on them.

So for example if my column has 300 occurances of a 3 word combo:

" go shopping today "

I can then do a find and replace on that phrase, I dont want to do word by word ones, only phrases. The reason for the grouping is to find the best options to change.

I know you can do this sort of thing:

SELECT DISTINCT str AS Word, COUNT(str) AS Frequency FROM tbl GROUP BY str;

but I feel this is something that will need to bring out the data into php, analyse and then drop back into mysql.

Any pointers?

Cheers

Rich