Since there's no function to count occurrences in strings, so I create a customized function to meet the requirement as followings:create function count_occurrences_case_sensitive(whole_string varchar(2048), match_string… Read More »How to Count Occurrences of a String in MySQL