Php Mysql find in set query /// i want to convert this query in laravel query builder

Question

select * from settings where setting_type='admin_privilege' and FIND_IN_SET ('001',`setting_value`) and br_id=4

Answer 1

You can do this:

DB::table('settings')
    ->where('setting_type', 'admin_privilege')
    ->where('br_id', 4)
    ->whereRaw("FIND_IN_SET ('001',`setting_value`)")