Link to home
Start Free TrialLog in
Avatar of brgdotnet
brgdotnetFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial