Count occurrences of a word in string
Jump to navigation
Jump to search
Count occurrences of a word in string
Excel
Using the function SUBSTITUTE & LEN functions. demo
MySQL way
SET @paragraph := 'an apple a day keeps the doctor away'; SET @term := 'apple'; SELECT FLOOR((LENGTH(@paragraph) - LENGTH(REPLACE(@paragraph, @term, ''))) / LENGTH(@term)) AS occurrences;
PHP
Using the mb_substr_count (binary safe) or substr_count function