title: MySQL SELECT rows which respond to specific MULTIPLE values in one of the columns
body: <p>I've looked all over the Web, and in StackOverflow as well, and have found many similar topics, but none that answers specifically my needs. So I'm sending this out there, knowing there's probably some little thing I'm missing in order for it to work.</p>
  
  <p>Let's imagine the following table:</p>
  
  <pre><code>      location  |   title   | description | quantity 
      ============|===========|=============|==========
        shelf     |   apple   |    red      |    2
        drawer    |   banana  |    yellow   |    4
        shelf     |   kiwi    |    green    |    2
        cupboard  |   lemon   |    yellow   |    1
        fridge    |   melon   |    orange   |    3
        drawer    |   peach   |    orange   |    1
  </code></pre>
  
  <p>What I want to do is select from this table all items that are either in the <code>drawer</code> or on the <code>shelf</code> (so <code>drawer</code> AND <code>shelf</code>) and then order them by, for example, first, location ascending and, second, quantity descending.</p>
  
  <p>So what I have (after searching all over the web) is the following code, which is the only one that doesn't return an error, <strong>but it doesn't return any items either:</strong></p>
  
  <p><code>SELECT * FROM items WHERE location = 'shelf' AND location = 'drawer' ORDER BY location ASC, quantity DESC</code></p>
  
  <p>Where am I going wrong? Any feedback will be greatly appreciated!</p>
  
  <p>Usually questions go toward how to select values from multiple tables and then join them. However, I need values from only one table; however, these values need to respond to specific multiple values they share.</p>