This updates search functionality to use the whereLike method, introduced in Laravel v11.17.0, for performing case-insensitive searches. For Laravel versions below 11.17.0, the existing implementation using like is retained.
The whereLike method adapts to the specifics of different databases:
PostgreSQL: Uses ilike for case-insensitive search.
MySQL: Uses like.
SQLite: Uses like.
SQL Server: Behavior depends on the column/database collation.
This updates search functionality to use the
whereLikemethod, introduced in Laravel v11.17.0, for performing case-insensitive searches. For Laravel versions below 11.17.0, the existing implementation usinglikeis retained.The
whereLikemethod adapts to the specifics of different databases:ilikefor case-insensitive search.like.like.