How to formulate where or statement, simple question

panzram

Hi,

I need the following sql:

SELECT * FROM x WHERE A=1 OR B=1

In my php file I can write

->where( 'A', 1, '=' )
->process( $_POST )
->json();

For a simple where, but how do I add the OR B=1?

tangerine

I believe that the Editor has an "orwhere" method.

->where( 'A', 1, '=' )
->orwhere( 'B', 1, '=' )
->process( $_POST )
->json();

I may be wrong, so read the docs.

panzram

Thx, I tried both orwhere and or_where (which I did find a reference to), but it didn't work...

allan

There isn't actually an or_where method on the Editor class - it exists on the Query class. So you'd need to use a closure function to be able to modify the query.

This is documented in the manual which a specific section on going exactly what you are looking for.

->where( function ( $q ) {
    $q
        ->where( 'A', '1' )
        ->or_where( 'B', '1' );
} );

Regards,
Allan

panzram

Excellent. Thank you for your, as always, relevant reply.