Laravel Query – Where In and Where Not In

Where In Query

SQL Query:

SELECT * FROM `users`

WHERE `id` IN (

SELECT `user_id` FROM `invite_users`

)

Laravel Query:

$users = DB::table(“users”)->select(‘*’)

->whereIn(‘id’,function($query){

$query->select(‘user_id’)->from(‘invite_users’);

})

->get();

 

Where Not In Query

SQL Query:

SELECT * FROM `users`

WHERE `id` NOT IN (

SELECT `user_id` FROM `invite_users`

)

Laravel Query:

$users = DB::table(“users”)->select(‘*’)

->whereNOTIn(‘id’,function($query){

$query->select(‘user_id’)->from(‘invite_users’);

})

->get();