In Old version of MySQL doesn't have any built in function to count number of occurrences of word in a string, so so we have to bit of tweak in your query to make this done in MySQL.
Now we have an option in MySQL To count the number of occurrences of a particular value in a MySQL table, you can use the COUNT function with a GROUP BY clause.
For example, if you have a table customers with a column region, you can use the following query to count the number of customers from each region:
SELECT region, COUNT(*)
GROUP BY region;
This will return a result set with one row for each region in the customers table, along with a count of the number of customers from that region.
You can also use a WHERE clause to count only the occurrences of a particular value. For example, to count the number of customers from the us-west-2, you can use the following query:
WHERE region = 'us-west-2';
This will return a single row with the count of customers from the us-west-2.