Laravel 5.1 detach with where

Question

I want detach without some records

my role_user table is id | role_id | user_id

<?php

   $user->roles()->detach();
?>

I don't want detach all records some records need (I mean find solution to where clause inside detach() ). How can I do this? Thank you.

Answer 1

Finnaly I found the solution

$user->roles()->wherePivot('role_id', '!=', 3)->detach();