In laravel, how to delete fixed number of rows from table using query builder?

Question

I am trying to delete any five rows from my users table. I used following code for that.

DB::table('users')->take(5)->delete();

But it deletes all rows in that table. How will I overcome this problem?

Answer 1

You said you want to delete 5 rows randomly, in this case this will work, I've tested it:

DB::table('users')->whereIn('id', DB::table('users')->orderBy(DB::raw("RAND()"))->take(5)->lists('id'))->delete();

It will take 5 random IDs and then will delete rows with these IDs with just two queries:

select `id` from `users` order by RAND() asc limit 5
delete from `users` where `id` in ('786', '186', '82', '578', '232')

Answer 2

You can use rand() function and delete users this way

DB::table('users')->DB::table('users')->orderby(RAND())->take(5)->delete();

Answer 3

You can use foreach

$users = DB::table("users")->orderBy(DB::raw("RAND()"))->take(5)->get();
foreach($users as $user){
    DB::table("users")->where("id", $user->id)->delete();
}

Answer 4

DB::table('users')->whereIn('id', DB::table('users')->take(5)->lists('id'))->delete();