sql - Mysql query, get exact value -
i have table 1 i'm trying chat_id members excat match example want chat id members 1,2 when select * member_to_chat member_id in (1,2) returns results , chat number 3, wrong because in chat have 3 people need if give member_id 1 , 2 chat_id 1, possible mysql, thank in advance! , sorry english if it's not good. 
member_to_chat
id | member_id | chat_id 1       1          1 2       2          1 ---------------------- 3       1          2 4       3          2 ---------------------- 5       1          3 6       2          3   7       3          3   the result given member_id 1,2 - chat_id has 1, or if pass 1,2,3 has return chat_id 3, thank again suggesstions
select distinct chat_id member_to_chat m not exists (select chat_id          member_to_chat          member_id not in(1,2)         , chat_id=m.chat_id) , exists        (select chat_id          member_to_chat          member_id=1) , exists        (select chat_id          member_to_chat          member_id=2)        
Comments
Post a Comment