Re: How to get no. of occurence of a word in a row using fulltext.

[Rick James]

I don't believe you can get the count from a FULLTEXT search. The metric available from MATCH is more complex -- it takes into account the length of the field being searched.

3 occurrences in a 100-word field is more significant than 3 occurrences in a 10000-word field.

For a single word ('test') in a single column (`freetext`):
SELECT
( CHAR_LENGTH(REPLACE('test', '', `freetext`) -
CHAR_LENGTH(freetext)) ) /
CHAR_LENGTH('test')
FROM tbl ...;
should give you the number of occurrences of 'test'. Unfortunately, it will include "retest".