How to search case insensitive in Eloquent model
I suggest Upper function in this case
Model::whereRaw("UPPER('{$column}') LIKE '%'". strtoupper($value)."'%'");
like this
Actually, 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.
Didn't see this solution. so I'm posting this here.
DB::table('products')
->select('productid')
->where(DB::raw('lower(product)'), 'like', '%' . strtolower($searchword) . '%')
->get();