Hi, how do i add unaccent (already works on psql server) to the following query: |> where( [a, b], ilike(a.title, ^“%#{search_string}%”) or ilike(b.name, ^“%#{search_string}%”) I know something with fragment. But not sure how to add it. Would really appreciate any help here. thanks

You are absolutly right with the index and the performance. But it is not so relevant here. But … Got it working :slight_smile: Here for anybody might looking for the same thing: |> where( [a], fragment("unaccent(?) ILIKE unaccent(?)", a.lastname, ^"%#{search_string}%") )

Putting unaccent in existing query

Questions / Help

Fl4m3Ph03n1x April 30, 2019, 8:35am 4

Would something like this be what you are looking for ?