Pages · Laravilt
Text Filter
Filter by text with contains, exact, prefix, or suffix matching.
php
Matching modes
| Method | SQL |
|---|---|
contains() (default) | WHERE col LIKE '%value%' |
exact() | WHERE col = 'value' |
startsWith() | WHERE col LIKE 'value%' |
endsWith() | WHERE col LIKE '%value' |
operator('>=') | WHERE col >= 'value' (any other operator) |
caseSensitive() is passed to the frontend. It doesn't change the SQL, so case sensitivity depends on your database collation.