Menu

#10 in() broken

open
nobody
None
5
2013-01-09
2008-10-19
No

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.

Discussion


Log in to post a comment.