How to parse a line of text in Sql

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?
Example:

Id      Text
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?
Id       TimesOccurred
1          2
2          1
3          4