I am trying to resolve an issue where using Laravel's query builder I am getting no results, but when I run the same query in php my admin i got result's..

This is the query:

```
DB::table('nm_product')->select(
    DB::raw(
        'IF(LOCATE(" ",pro_title,POSITION("'.$products
        .'" IN pro_title))<>"0",SUBSTR(pro_title,POSITION("'.$products
        .'" IN pro_title),LOCATE(" ",pro_title,POSITION("'.$products
        .'" IN pro_title)) - POSITION("'.$products
        .'" IN pro_title) ) , "aaa")  as keyword'
    ),
    'mc_name',
    'pro_title'
)->join('nm_maincategory', 'mc_id', '=', 'pro_mc_id'
)->where(DB::raw('LOWER(pro_title)'),'like','"% '.$products.'%"'
)->orwhere(DB::raw('LOWER(pro_title)'),'like','"'.$products.'%"'
)->get();

```