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?