Hopefully a quick one - I hav a table full of words and phrases and trying to return anything over length 15 without being multiple words (i/e/ no spaces).
So far I have:
WHERE length( trim( word ) ) >15
LIMIT 0 , 30
But need to exclude phrases with spaces - had a look at REGEXP '[:space:]' but can't seem to get that to work in the query.
So a sudo query:
select * from words where word is longer than 20 but make sure it is a word and not a phrase with spaces