Column Search - Prefix match

beerygaz

I'm using column search fields, and would like to execute the search on a "Starts with" basis or the equivalent of LIKE "<search string>%" in SQL. Right now it matches the characters anywhere in the column content, even with "smart search" set to false.

colin

Hi @beerygaz ,

You can use a regular expression column search with this column().search() and add "^" to the start of the search string - that will only match when that string is at the beginning.

Cheers,

Colin

beerygaz

Thanks for the quick answer colin, I'll give that a try.