SQL count number of words in field

Question

I'd like to make an SQL query where the condition is that column1 contains three or more words. Is there something to do that?

Answer 1

maybe try counting spaces ?

SELECT * 
FROM table
WHERE (LENGTH(column1) - LENGTH(replace(column1, ' ', ''))) > 1

and assume words is number of spaces + 1