Querying an array of strings with a string that represents search terms
0
votes
1
answer
1361
views
I have an array of values like:
array ('hello world', 'foo', 'bar') -- terms here have only letters and one space at most
and some text like:
'foo hello-world hello1world'
and I would like to get back from the original array the values foo
and hello world
filtering out bar
.
Is there any way to get that with Postgres?
Asked by Randomize
(1203 rep)
Sep 25, 2017, 04:10 PM
Last activity: Mar 4, 2020, 06:02 AM
Last activity: Mar 4, 2020, 06:02 AM