CODEWITHSUNDEEP
phpmysqllaravel-5
uma
uma

Reputation: 1577

How to write this query using Laravel 5 Query Builder?

I want to write this Sql query using in Laravel 5 Query Builder.

SELECT  * FROM Call WHERE phone_number NOT IN (SELECT phone_number FROM Phone_book)

or(Alternative way)

SELECT * FROM   Call
         LEFT OUTER JOIN Phone_Book
          ON (Call.phone_number = Phone_book.phone_number)

or(Alternative way)

   SELECT * FROM   Call
        WHERE  NOT EXISTS
          (SELECT * FROM   Phone_book
             WHERE  Phone_book.phone_number = Call.phone_number)
               WHERE Phone_book.phone_number IS NULL

I tried several ways but i couldn't write a query.is there any way to use Sql syntax with in query builder or how write this same query using Query Builder? please , help me.

(I tested above 3 query out put is same . I want to write these one query using Query Builder syntax)

Upvotes: 0

Views: 72

Answers (1)

Kuang
Kuang

Reputation: 25

DB::table('Call')->whereNotIn('phone_number', function($query)
{
    $query->select('phone_number')
        ->from('Phone_book');
})
->get();

This code is absolutely same with the first sql query u posted.

Upvotes: 2

Related Questions