WHERE related field has ALL values in list (AND)

[brockfanning]

Sorry for asking a blatant support question here!

I am trying to get all pods of post_type "news" that are tagged as BOTH "term_1" and "term_2". I'm able to do ORs, but I can't seem to figure out the AND. I had been trying to do this all in the "where" statement, but with no success. Do I actually need to do some manual JOINs?

Any tips to point me in the right direction? Thank you!

[sc0ttkclark]

@brockfanning Yes, you would need to do manual joins to check on BOTH, as MySQL itself doesn't allow for ALL matches, only IN which is essentially an ANY.

[sc0ttkclark]

Great deal of ideas and information here: #1978

[sc0ttkclark]

Fixed by #3033

[sc0ttkclark]

Following up with the example usage here:

$pod->find(
    [
        'where' => [
            [
                'field' => 'category.name',
                'value' => [
                    'first',
                    'second',
                ],
                'compare' => 'ALL',
            ],
        ]
    ]
);