title: MySQL list queries equal to multiple values
body: <p>I am trying to list people from California, Los Angeles who are male or female but I don't want all males and females from California to be listed.</p>
  
  <pre><code>SELECT * FROM people 
  WHERE state='california' 
      AND city='los_angeles' 
      AND gender='male' OR gender='female'
  </code></pre>
  
  <p>I also tried: </p>
  
  <pre><code>SELECT * FROM people 
  WHERE city='los_angeles' 
      AND gender='male' OR gender='female'
  </code></pre>