Efficient way to query sql like in firebase

Question

What's the updated and effient way to query sql like in firebase? I've search in forums and they say I should query all the documents then just do a javascript match function

Does this answer your question? [Firebase Database in SQL](https://stackoverflow.com/questions/42222347/firebase-database-in-sql) — michaeldel, Apr 30 '20 at 03:35
See Doug's answer. Additionally, you may get a more specific answer if you can update your question with the query you're trying to do. Include a description of the query, what your Firebase structure looks like and what the desired outcome is. — Jay, Apr 30 '20 at 16:17

Doug Stevenson · Answer 1 · 2020-04-30T17:15:53.767

Neither database provided by Firebase (Realtime Database and Firestore) have support for LIKE queries. This is not going to change any time soon, as these types of queries do not scale with the sort of indexes provided by these database.

You can do string prefix queries, which is similar to "WHERE field LIKE foo%", but that's all you get.

For Realtime Database, see:

For Firestore, see:

Efficient way to query sql like in firebase

1 Answers1