0
select * from settings where setting_type='admin_privilege' and FIND_IN_SET ('001',`setting_value`) and br_id=4
shaedrich
  • 5,457
  • 3
  • 26
  • 42
gaurav coding HUB
  • 11
  • 2
  • 2
    Does this answer your question? [Using find\_in\_set() in laravel where clause](https://stackoverflow.com/questions/55740187/using-find-in-set-in-laravel-where-clause) – Ghanshyam Nakiya Jul 28 '21 at 09:17

1 Answers1

0

You can do this:

DB::table('settings')
    ->where('setting_type', 'admin_privilege')
    ->where('br_id', 4)
    ->whereRaw("FIND_IN_SET ('001',`setting_value`)")
shaedrich
  • 5,457
  • 3
  • 26
  • 42