Search and match each word
Search and match each word

Hi,
I would like to make a global search, abled to find multiple words and match each of them anywhere in the row.
I explain:
My table has a column "name" and a column "city". In the search input, if I enter "jo ma", it will return the rows:
- John, Roma
- Joe, Madrid
- Mary, Johannesbourg
But it will not return Johnny, Paris
I can not find how to make it
This discussion has been closed.
Answers
This example from this thread should get you going, it's doing that. It's using regexes in
search()
. See also this example as a good way to experiment with those things.Colin