Android Rooms - Search in String

Question

In the Android Rooms persistence library, how would I write the following SQL statement as a @Query?

SELECT * FROM table WHERE field LIKE %:value%

This syntax is invalid, and I can't find anything about it in the documentation.

@Spiderman I'm talking about the new Rooms persistence library. I know how to write it in regular sql :) — Roi Divon, May 29 '17 at 06:51
Possible duplicate of [Android Room - Select query with LIKE](https://stackoverflow.com/questions/44184769/android-room-select-query-with-like) — Krzysztof Skrzynecki, Jun 09 '17 at 00:45

score 34 · Accepted Answer · edited Jul 09 '20 at 20:40

34

You can just concatenate using SQLite string concatenation.

@Query("SELECT * FROM table WHERE field LIKE '%' || :value  || '%'")

edited Jul 09 '20 at 20:40

Peter Mortensen

answered Jun 09 '17 at 02:57

yigit

1

what if I want the `field` starts with `:value`? Thank you :) – Ahmed Mostafa Oct 22 '17 at 22:26
@AhmedMostafa @Query("SELECT * FROM table WHERE field LIKE :value || '%'") – Oktawian Mar 20 '21 at 08:30

score 4 · Answer 2 · edited Jul 09 '20 at 20:37

4

The answer by yigit works great for me:

@Query("SELECT * FROM stores " +
        "WHERE name LIKE '%' || :search  || '%' " +
        "OR description LIKE '%' || :search  || '%'")

edited Jul 09 '20 at 20:37

Peter Mortensen

answered Aug 24 '18 at 17:46

Ufere Peace

2 Answers2