If you are using Postgres, you don’t need to use UPPER
, just use ilike
as the comparator and it will do a case-insensitive comparison.
Model::where('column', 'ilike', '%' . $value . '%')
You do need the %
signs to signify the substring you’re searching for.