use of in Keyword IN keyword in Query

select * from resource 开发者_高级运维 where ResourceID= 1 and ResourceKeyword in(gallery 1,1980)

I have an table called resource with columns ResourceID, ResourceKeyword

ResourceKeyword can contain multiple values when ever I am using this query

I get an syntax error

what is syntax to solve it

thank you

Random guess, string delimiters

select *
from resource
where ResourceID= 1 and ResourceKeyword in('gallery 1','1980')