title: Mysql Query use of AND
body: <pre><code>Contest
  contest_id  Launched        name
  -------------------------------------------------------------------------
  1           0               Cont1
  2           1               cont2
  
  participants
  participants_id       group_id       contest_id      puser_id
  -------------------------------------------------------------------------
  1                     1              1               555
  2                     1              1               666
  
  fusers
  fuser_id    name
  -------------------
  555     Alex
  666     sabrina     
  </code></pre>
  
  <p>I need to write up a query that will select all users(name,groupid,contestname) who are participants of all contests
  Details of all users are in <code>fusers</code>, where as contest has all contest hosted Launched should be 1 and participants is the table that contains id of users who have decided to participate in a contest.
  <code>fuser_id = puser_id</code></p>
  
  <p>Want to find who is participating in contest_id=1 there group_id,contestname and name</p>