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