Code: Select all
SELECT MemberId FROM parliament_members, parliament_sitting_logs WHERE parliament_members.pmid IN(parliament_sitting_logs.speakers) AND lid = '23'
# where speakers has a comma separated value of 66,77,50
Code: Select all
SELECT MemberId FROM parliament_members, parliament_sitting_logs WHERE parliament_members.pmid IN(66,78,50) AND lid = '23'
can the IN() function work like that?