How to search a data for specific field value whose first character(s) matches the data field in fire store

Question

I want to search the dataset in Firestore whose starting character(s) matches the data as for this example:

I am building an application in which I save the record for cars in cars collection and there is a data field of carName for every car document. If I have car named as "BMW" and "Belta" then I only type "B" to search the car and it gives me results for both "Belta and BMW" by matching the first character

Is this possible?

If my query is not conveying properly then please tell me and I will make the question more readable.

You can try use 'whereGreaterThanOrEqual' - FirebaseFirestore.getInstance().collection("CarsCollection").whereGreaterThanOrEqualTo("CarName", "al"); — MukulSharma, Mar 22 '21 at 16:25

score 0 · Accepted Answer · answered Apr 28 '21 at 12:38

Yes, it is possible.

Following your example, for searching cars that start with "B" you could try:

db.collection('cars')
    .where('carName', '>=', 'B')
    .where('carName', '<', 'C');

If you would like to do that with any letter, you could check here for different examples on how to do it.

1 Answers1