The following oracle query purports to output a word count for all words found in a table column. Is this possible in MYSQL?
Mike
================================================== =
Measuring of word frequency in text data SQL query:
select Word, count(*) Frequency
from
(
select substr(text, instr(' '||text, ' ', 1, n),
instr(' '||text||' ', ' ', 1, n+1)-instr(' '||text, ' ', 1, n)-1) Word
from
(
select translate(lower(comments),
',.!?:;''"()[]{}<>-+=*/\$#%&^@|'||chr(9)||chr(10),
' ') text
from all_tab_comments
where owner = 'SYS'
and comments is not null
), rowset
where nvl(instr(' '||text||' ', ' ', 1, n+1), 0) > 0
and instr(' '||text||' ', ' ', 1, n+1)-instr(' '||text, ' ', 1, n)-1 > 0
and n < 40
)
group by word
order by 2 DESC