I need to parse a word out of a column of text, and then print out the number of times it occurs. Can someone show me how to do that in SQL?
1 Today is a happy day because the weather is happy
2 be happy
3 be happy because when you are not happy you will be un happy, so be happy
So the sql query I need would print out the following. Can someone show me how to do that?