Count occurrences of a word in string

From LemonWiki共筆
Revision as of 20:30, 7 August 2019 by Planetoid (talk | contribs) (+ PHP)
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

Retrieved from "https://wiki.planetoid.info/index.php?title=Count_occurrences_of_a_word_in_string&oldid=20846"