Article From:https://segmentfault.com/q/1010000012154874
Question:

SQLiteCan where in and like be used together

Answer 0:

For example?
If you are in two conditions, you can use and or or to combine.
If you are where col like in, or where col in (like…), this is obviously not acceptable.

Answer 1:
--If you connect `and` `or` with `in` and `like`, there is nothing wrong with it.SELECT * FROM [TableName] WHERE Tree Like '%, 9555,%' AND MakeTypeIN (1,2)SELECT * FROM [TableName] WHERE Tree Like '%, 9555,%' OR MakeType IN (1,2)

Leave a Reply

Your email address will not be published. Required fields are marked *