in() broken
Brought to you by:
mattlewis
This query has only one value in the in() filter and returns ALL records (even those not matching the in() filter):
select member_id,associate_member,first_level_count,join_date,upline_id from members where upline_id in (5432976148) order by JOIN_DATE
This query works fine:
select member_id,associate_member,first_level_count,join_date,upline_id from members where upline_id in (5432976148,0) order by JOIN_DATE
So, if only one value is in the in() filter, it doesn't work properly.