like()

[Orange-Men]

Hi!
branch: "ecto-2.1"
I trying to use like/2.
But something is broken and I get the error:

** (Ecto.QueryError) Invalid expression for MongoDB adapter in where clause in query:
from a in MyApp.Airport,
       where: like(a.city, "Br%"),
       select: a

source code:

    query = from a in Airport, where: like(a.city, "Br%")
    Repo.all(query)

[ankhers]

like/2 does not translate to non-SQL databases well. The syntax used is very specific to SQL. Have you taken a look at the regex module that this package provides? Maybe that can help you in this scenario.

[Orange-Men]

@ankhers Thank you very much!