Working in Laravel 5.1 I need to get the data for this query :
$query = "top";
$data['rawQuery'] = "category_names REGEXP '(?<![a-zA-Z])".'{?}'.'((es)?|(s?))(?![a-zA-Z])';
 $data['bindParams'] =  [$query];
 $result = DB::table($this->table)
                    ->whereRaw($where['rawQuery'], isset($where['bindParams']) ? $where['bindParams'] : array())
                    ->select($selectedColumns)
                    ->get();
I am unable to put my bind param to proper position which should be like this:
 select * from product_categories where category_names REGEXP '(?<![a-zA-Z])top((es)?|(s?))(?![a-zA-Z])
Whereas I am getting this:
select * from product_categories where category_names REGEXP '(tops<![a-zA-Z]){?}((es)?|(s?))(?![a-zA-Z])
The difference is that , my query value is setting to wrong place. Please show some light on this .
via subhajit
