Query filter - how to use regex

Mr_English

Table = places

Column = placename

I want to find all records where placename begins with the content of variable placeNameStr.

The 'regex matches' operator seems a good fit for this. However, the example below does not work. I also tried /^placeNameStr/

The example in the screenshot generates this error:

{"message":"mb_stripos(): Argument #1 ($haystack) must be of type string, array given"}

I would also need it to handle upper or lower case input - i.e. the user could enter 'bri', 'Bri', BRI' etc.

Any suggestions please?

Pawel Magdanski

The error you are having right is related to the wrong data type. Is places.placename an array?

Pawel Magdanski

Have you considered using fuzzy_search with wildcard matching?

Pawel Magdanski

No problem, happy to help

Mr_English

@Pawel Magdanski

The column is Text.

Mr_English

From the UK

When are our American friends going to wake-up? I've been working for two hours already!

Mr_English

@Pawel Magdanski thanks for your response. got it working. Thanks a lot.