Combining IN AND LIKE operators

Is there any method 开发者_开发问答to do this:

SELECT * FROM `cores` WHERE superkinds IN ('%altro%', '%feste%')

Thanks

WHERE superkinds LIKE '%altro%'
OR superkinds LIKE '%feste%'

Not with IN, only with OR.

Use RLIKE or REGEXP with a valid regular expression.