Two conditions in SQL query with Laravel 4

Question

Two conditions in SQL query with Laravel 4

Navigation

#1 by (2 votes)

4

I need to query MySQL with two conditions. I tried to do this:

$query=DB::table('veteranos')->where('ra', '2300')->where('flag', 0)->pluck('ra');

In this way, the second condition is not working, that is, the query takes values other than 0 for flag . What would be the correct way to do this query?

mysql laravel-4

asked by anonymous 21.12.2015 / 13:04

1 answer

I can not persist the data in the Bank Search with MySQL PDO in Array

score 2 · Accepted Answer

You can do two functions. The second function receives the result of the first query as a parameter.

DB::table('veteranos')->where('ra', '2300')
            ->where(function($query){
                return $query
                          ->where('flag', 0)->pluck('ra');