ohmyohmyohmy
How to perform a query with 'like' using sqlite through Ecto
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.24.1 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
Marked As Solved
ohmyohmyohmy
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
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"