I need to do auto completion on site, I use laravel. now it work like this:
Group:: whereRaw( where lower (name) like lower ('$q%'))->get ()
But it is not safe I try do like this:
$q="a"; group:: whereRaw("lower (name) like lower ('?%')",[$q])->get ()
always return empty array, but
$q="a"; group:: whereRaw("lower (name) like lower ('$q%')")->get ()
return correct result