Laravel SQL Query in Eloquent?

Question

How would I achieve this SQL query in Laravel's eloquent?

"SELECT * FROM `cardfields` 
WHERE cardfields.id NOT IN (select fieldassociation.field_id 
from fieldassociation where fieldassociation.card_id = $cardid)"

The Alpha · Accepted Answer · 2016-03-17 17:19:54Z

2

To use Eloquent you need models with some relationships between the models (when models are created) but if you use QueryBuilder then you may do it using something like this:

DB::table('cardfields')->whereNotIn('id', function($query) use($cardid) {
    $query->select('field_id')
          ->from('fieldassociation')
          ->where('card_id', $cardid);
})
->get();

Make sure you import the DB using use keyword or use \DB instead of DB.

answered Mar 17, 2016 at 17:19

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

Collectives™ on Stack Overflow

Laravel SQL Query in Eloquent?

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