firebase: implementing pattern searching in firebase

I know there is no WHERE clause in firebase. But how we can implement pattern searching in firebase as we can do in SQL using LIKE operator.

How we can implement following sql query in firebase?

SELECT * FROM Customers WHERE City LIKE 's%';