'Find number of count of a word in column in each row

I have a table name 'answer' and where answer saved given by a user for a question. User give multiple answer of a question.So answer save as string in 'answer' column. My table look like this

id  userid   questionid  answer
 
1   2        5           red,blue,white,green

2   3        5           red,blue

3   5        5           red,white

4   6        5           blue,white,green

5   7        5           red,blue,white,green      

I want to select those userid whose answer 3 value(blue,white,green) or more than 3(red,blue,white,green). I have tried with length function but it not work.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source