I use RoomDatabase in android studio, and I have a table of users, something like this:
| firstname | lastname |
|---|---|
| Michael | Scott |
| Dwight | Schrute |
What query should I write in the UserDao to search in a couple of rows at once? I want something like this:
SELECT * FROM tblUsers WHERE * LIKE "%str%"
Do you have an idea?
I don’t want to use a lot of OR because than it’ll only show me “Michael Scott” if I’ll enter either “Michael” or “Scott”, but when entered together it’ll show nothing.
