Android Room – Select query with LIKE

by

You can just concat using SQLite string concatenation.

@Query("SELECT * FROM hamster WHERE name LIKE '%' || :search || '%'")
fun loadHamsters(search: String?): Flowable<List<Hamster>>

More Related Contents:

  1. Android Room – simple select query – Cannot access database on the main thread
  2. Room Persistence: Error:Entities and Pojos must have a usable public constructor
  3. How can I represent a “many to many” relation with Android Room when column names are same?
  4. How to save enum field in the database room?
  5. How to make primary key as autoincrement for Room Persistence lib
  6. startForeground fail after upgrade to Android 8.1
  7. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  8. How to fix ERROR: No signature of method: build_ap86oam3dut3pxce3x49rdtma.android()?
  9. Kotlin Error : Could not find org.jetbrains.kotlin:kotlin-stdlib-jre7:1.0.7
  10. Android room persistent library – TypeConverter error of error: Cannot figure out how to save field to database”
  11. Error: Execution failed for task ‘:app:clean’. Unable to delete file
  12. How are Android activities handled with Jetpack Compose and Compose Navigation?
  13. The ‘kotlin-android-extensions’ Gradle plugin is deprecated
  14. Why a viewmodel factory is needed in Android?
  15. Jetpack Compose collapsing toolbar
  16. Could not deserialize object. Class does not define a no-argument constructor.If you are using ProGuard, make sure these constructors are not stripped
  17. Android room persistent library – how to insert class that has a List object field
  18. Jetpack Compose Smart Recomposition
  19. No Creators, like default construct, exist): cannot deserialize from Object value (no delegate- or property-based Creator
  20. Can’t create new Kotlin project after updating to Android Studio 4.2
  21. ‘setHasOptionsMenu(Boolean): Unit’ is deprecated. Deprecated in Java
  22. Room : LiveData from Dao will trigger Observer.onChanged on every Update, even if the LiveData value has no change
  23. FirebaseMessaging.getInstance(firebaseApp) for secondary app supposed to be public but it’s private?
  24. Execution failed for task ‘:app:checkReleaseDuplicateClasses’
  25. Close/hide the Android Soft Keyboard with Kotlin
  26. How I can retrieve current fragment in NavHostFragment?
  27. Kotlin Coroutines the right way in Android
  28. FragmentTransaction hide/show doesn’t work sometimes
  29. Kotlin Android debounce
  30. kotlin-stdlib-jre7 is deprecated. Please use kotlin-stdlib-jdk7 instead

Leave a Comment