How to implement partial word search in PostgreSQL for a RoR project?

Question

PostgreSQL

Hello!
Can you please tell me how to implement a search in a table for a specific field using part of a word?
For example, for the query "mar", I should display the names:
- Mark
- Lamar
- Maria
- Margot
Tried this gem - https://github.com/Casecommons/pg_search , but the problem is that with it I could only implement the search by whole name. That is, at the request "Margo" it will give me all Margo, and at the request "mar" there will be emptiness (there are no records in the table).
I would be very grateful if you could suggest a suitable gem or implementation using pg_search. Well, or there are some other alternatives for implementing this idea.

Answer 1

query = "мар"
User.where("name ILIKE '%?%'", query)