I would like to run something like:
select * from table where field in ("%apple%", "%orange%")
Is there a way? Or at least is there a better way than dynamically building query for every keyword:
select * from table where field like "%apple%" or field like "%orange%"
Thanks.