mysql - Convert SQL to Laravel Query Builder with complex AND OR -

i have query this-

select * subscribers_lists   country='germany'   , (city='berlin' or name '%mün%'); 

i want convert laravel query builder's query. so, have done -

db::table('customers')     ->where('subscribers_lists.country', '=', $user_country)     ->or_where('subscribers_lists.city', '=', $user_city)     ->or_where('subscribers_lists.name', 'like', '%' . $searchparameter . '%'); 

but not working perfectly. suggestion, please?

thanks helping.

you can use closure create complex part.

db::table('subscribers_lists')     ->where('subscribers_lists.country', '=', $user_country)     ->where(function($query) use ($user_city, $searchparameter) {         $query->where('subscribers_lists.city', '=', $user_city)               ->orwhere('subscribers_lists.name', 'like', '%' . $searchparameter . '%');     }); 

you can read more advanced queries in documentation here