How to perform a query with 'like' using sqlite through Ecto

Questions / Help
,
1

I have an SQLite query I’d like to perform using Ecto:

select * from testtable where text like ‘%hel%’;

Checking Ecto.Adapters.SQLite3 — Ecto SQLite3 v0.22.0 seems to imply there’s support for case insensitive searches by the default of case_sensitive_like being off, but when I try a query with like, it tells me it is not supported:

    query =
      from p in My.Custom.Schema,
        where: ilike(p.text, "hel"),
        select: p

(Ecto.QueryError) ilike is not supported by SQLite3 in query:

What’s the correct way to get what I want, or is it not possible? Thanks

2

I think I answered my own question. Don’t use ilike/2. Use like/2. So, the correct way is

  query =
      from p in My.Custom.Schema,
        where: like(p.text, "%hel%"),
        select: p
1 Like