How do I design a database/query that queries users's answers to user tags
(
&quot;usertaganswer_answeredoptions&quot;.&quot;userTagAnswerOptionId&quot; = '5' 
or &quot;usertaganswer_answeredoptions&quot;.&quot;userTagAnswerOptionId&quot; = '6'
or &quot;usertaganswer_answeredoptions&quot;.&quot;userTagAnswerOptionId&quot; = 4 
) 

but I don't want an 'or' of all the criteria I want an 'and'. But if I do the following, it will return zero results even thought it should return 1

Zero is the correct result.
usertaganswer_answeredoptions.userTagAnswerOptionId can have the single value at the time. It cannot be at the same time equal to 4, 5 and 6. It can be (4 OR 5 OR 6) not (4 AND 5 AND 6).