Search for multiple words in a string with partial matching POSTGRESQL

Question

I currently search for multiple words in a string like this:

select name from restaurant where regexp_split_to_array(lower(name), '\s+') @> array['bar', 'food'];

Which splits the string in an array like this: The Food Bar = [the, food, bar]

But it only works if the full words are in the string. I want to get the same result if I use "ba" and "foo" for example. How can I achieve it?

Laurenz Albe · Accepted Answer · 2020-11-04 19:45:56Z

3

Full text search may do the trick:

WHERE to_tsvector('simple', name) @@ to_tsquery('simple', 'the:* | food:* | bar:*')

answered Nov 4, 2020 at 19:45

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Is ranking the results possible?

@KevinWaterson Should be.