Character start with query in room persistent android

Question

I have tried the following query but it does not give any result.

SELECT * FROM details WHERE name LIKE :name

I have used AutoCompleteTextview for searching purpose. is there any query to find with a substring?

Answer 1

Like MoinKhan suggested, adding the wildcard to the string before sending to Room worked for me.

query = "%"+query+"%";

Answer 2

I recently ran into this issue and found the nicest solution is to use Sql string concatenation || in combination with % which represents zero, one, or multiple numbers or characters.

@Query("SELECT * FROM details WHERE name LIKE '%' || :name || '%'")
fun getDetails(name: String): details

This will get the details where the name contains the one we are looking for

Similarly the below will find matches that start with the name

LIKE :name || '%'