Strange behavior when trying to compare field with 0 in where clause

Question

Let's say I have 2 entries in my db:

--  Name  -- approved -- resolved
-- Record1 --    1     --    0
-- Record2 --    1     --    1

I am fetching records with Where clause

$results = DB::table('mytable')->where('mytable.approved','=',1)->where('mytable.resolved','=',0);

The strange behavior is that it refuses to fetch the string Record1

if resolved=0

,

if i change the request to

$results = DB::table('mytable')->where('mytable.approved','=',1)->where('mytable.resolved','>',0);

He removes Record2

.

Anyone have an idea what happened?

I tried to play with the field type and make it boolean and null, didn't help.

+3

emc Dec 18 14 at 11:19

1 answer

Shahid ahmad · Answer 1 · 2014-12-18T12:20:14+0000

Hey Using whereRaw might be lower than code work for you

$ results = DB :: table ('mytable') → whereRaw ("mytable.approved = 1 AND mytable.resolved = 0");

try it

it solved your problem.