How to detach only the last record in the pivot table using detach() in Laravel 4?

Question

If I do this:

return $this->roles()->detach($role);

all roles are removed.

How to limit that to only the last one?

Answer 1

You can do it without timestamps:

$lastRole = $user->roles()
    ->orderBy( $user->roles()->getTable() .'id', 'desc')
    ->first();
$user->roles()->detach($lastRole);

or with timestamps:

$lastRole = $user->roles()->latest()->first();
$user->roles()->detach($lastRole);