Dear friends!

Can I use SQL to count the occurences of a word in a text column?

I don't want to count the number of rows. If the word "flower" occurs twice in one row and once in another row, I want the counter to tell me there are 3 hits (word occurrences), not 2 (relevant rows).

/Beetrader
slask at fornyelsebutiken dot com