Combining IN AND LIKE statements

Question

Is there any way to do this:

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

thank

Answer 1

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

Answer 2

Not with IN, only with OR.

Answer 3

Use RLIKEor REGEXPwith a valid regex.