How to perform a quick search by occurrences?

Question

PostgreSQL

Good afternoon! There is a need to implement on occurrences. From the postgres documentation I found how to search for records starting with the query to_tsquery('Willow:*'). But I need to do a search for an occurrence in a word. I can not find how to build a query correctly.

Answer 1

Finding the exact occurrence of a substring in a string? LIKE '%...%'
Plus trigram index from pg_trgm contrib