I have an list of strings:

val mylist = listOf("cat","flower")

and a table that has a string typed column named question I can write the query to find questions that are exactly matched with one of list items:

@Query("SELECT * FROM objects WHERE question IN (:mylist)")
List<Object> queryObjects(List<String> mylist);

But in fact the question column data is not of single word type, but string. I need to find results that every one of the list items are in that strings .for example the record : is this a cat

CodePudding user response：

The use of IN is basically an = test of the expression on the the left of the IN clause against the list of values on the right. That is only exact matches are considered.

However, what you want is multiple LIKE's with wild characters, and an OR between each LIKE e.g question LIKE '