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.