How to select specific fields from pivot table that matches exact values

Discussion in 'MySQL' started by Kuna, Dec 6, 2021.

0
  1. #1
    I have 3 tables
    - conversations - I save basic information about the conversation
    - users - Infor about user
    - conversation_users - table that saves information about which user belongs to which conversation

    In my case user "1" wants to get a conversation between him and users: 3, 4, 5. So I'm trying to fetch conversation_id = 12. First I need to find all conversations user "1" belongs to, that is conversation_id "1" and "12".

    Next I'm executing `SELECT * FROM conversations_users WHERE conversation_id in (1,12)`. How do I pick rows marked in red rectangle?

    [​IMG]
     
    Kuna, Dec 6, 2021 IP