CODEWITHSUNDEEP
mysql
Luca Romagnoli
Luca Romagnoli

Reputation: 12455

Combining IN AND LIKE operators

Is there any method to do this:

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

Thanks

Upvotes: 3

Views: 792

Answers (3)

Taylor Leese
Taylor Leese

Reputation: 52310

Use RLIKE or REGEXP with a valid regular expression.

Upvotes: -1

Amy B
Amy B

Reputation: 17977

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

Upvotes: 4

David M
David M

Reputation: 72870

Not with IN, only with OR.

Upvotes: 2

Related Questions