Search and match each word

Search and match each word

damienmedandamienmedan Posts: 1Questions: 1Answers: 0

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

Answers

  • colincolin Posts: 15,237Questions: 1Answers: 2,599

    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

Sign In or Register to comment.