Generate unique slugs in Laravel 4 (updated)

gistfile1.php

    function generateSlug($value)
    {

        $slug = \Str::slug($value);

        $slugs = $this->whereRaw("slug REGEXP ? ", ["^{$slug}(-[0-9]*)?$"]);
        $count = $slugs->count();

        if ($count === 0) {
            return $slug;
        }

        return $slug = $slug . '-' . ($count + 1);
    }