Laravel 5 query builder where exists example

By Hardik Savani | March 7, 2016 | | 55541 Viewer | Category : PHP Laravel MySql


you use sql where exists clause in laravel. whereExists through you can use sql where exists clause in your laravel project. It is very easy to use and you can easily undestand. You can give SELECT statment in where condition. you can see bellow example and you can learn how to use whereExists in your app.

SQL Query

SELECT *

FROM `items`

WHERE EXISTS

(SELECT `items_city`.`id`

FROM `items_city`

WHERE items_city.item_id = items.id)

Using Laravel Query Builder

DB::table('items')

->whereExists(function ($query) {

$query->select("items_city.id")

->from('items_city')

->whereRaw('items_city.item_id = items.id');

})

->get();



Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.