Why laravel query doesn't return right result?

Question

I have this code in laravel to get the products that will run out soon.

$productos = DB::table('productos')
                  ->where('producto_minimo', '>=', 'producto_cantidad')
                  ->get();

And what I get is the following result

Laravel Result

which is not the right result. While in MySql I get the right results whith this query SELECT * FROM productos where producto_minimo >= producto_cantidad;

MySql Result

Update
The query log - DB::getQueryLog() - shows this

  2 => 
    array (size=3)
      'query' => string 'select * from `productos` where `producto_minimo` >= ?' (length=54)
      'bindings' => 
        array (size=1)
          0 => string 'producto_cantidad' (length=17)
      'time' => float 1

I'd truly think actually posting the result instead of posting a picture will be easier on all of us. — Idris
– Idris, Commented Aug 4, 2014 at 15:47
Have you tried enabling debug=true in database.php so that you can log the actual database queries that are executed? — Mark Baker
– Mark Baker, Commented Aug 4, 2014 at 15:49
@giannischristofakis the id 4 should be the only result, but I get all the rows in the table. — laviku
– laviku, Commented Aug 4, 2014 at 15:50
Yeah, first result is way wrong: producto_minimo = 10 which is < than producto_cantidad = 20... — Antonio Carlos Ribeiro
– Antonio Carlos Ribeiro, Commented Aug 4, 2014 at 15:55

VMai · Accepted Answer · 2014-08-04 16:01:12Z

4

I assume you've got to use the whereRaw method:

$productos = DB::table('productos')
                  ->whereRaw('producto_minimo >= producto_cantidad')
                  ->get();

Your query will compare the value in the column producto_minimo with the string 'producto_cantidad'

Have a look at Eloquents documentation of advanced wheres:

DB::table('users')
        ->whereExists(function($query)
        {
            $query->select(DB::raw(1))
                  ->from('orders')
                  ->whereRaw('orders.user_id = users.id');
        })
        ->get();

The query above will produce the following SQL:

select * from users
where exists (
    select 1 from orders where orders.user_id = users.id
)

answered Aug 4, 2014 at 16:01

VMai

10.4k9 gold badges28 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why laravel query doesn't return right result?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related