How to do extra word search in postgresql?

Question

PostgreSQL

Good afternoon!
The table has 2 entries:

id, some_name
1, привет мир
2, привет замечательный мир

How can I make a search on the string hello wonderful world to return both lines 1 and 2?
Now the request looks like this:

select * from my_data where to_tsvector(some_name) @@ to_tsquery('привет замечательный мир');

And accordingly I receive selection only 2 lines. What can be done to make the first row also included in the selection?

Answer 1

replace the word that is not important with the symbol % and the condition should be where field like 'xxx % yyy'

Answer 2

Well, probably like this:

select * from my_data  where to_tsvector(some_name) @@ to_tsquery('привет | замечательный | мир');

tsquery supports the &, |, !, <->and bracket grouping.
https://www.postgresql.org/docs/current/datatype-t...