LIKE / ILIKE search

[pivotal-casebook]

We could make a trivial search that uses SQL LIKE and ILIKE. It ought to be database-agnostic.

[nertzy]

This hasn't been important in the last five years so I'll close it.

[nertzy]

Reopening since someone has asked for it in #356

[maxgronlund]

looking for a way to find users where their email ends with '@example.com'

[nertzy]

Without pg_search, you could do with with something like User.where("email ILIKE '%@example.com'")

See https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE

[3pns]

Any reason/problem why this has not been integrated in pg_search for the past decade ? Although it is possible to write raw SQL, being able to use LIKE/ILIKE through pg_search would be cleaner.

I'd be happy to work on a pull request if @nertzy will consider it.

[nertzy]

I would consider it. There are a lot of moving parts involved with implementing a pg_search feature, such as how they work with each other with weighting, etc., so it might be difficult, but it's definitely worth a shot.