title: Query data values where keys are different
body: <p>I am having a little bit logic issue with querying data.</p>
  <p>I have table with <code>key</code> and <code>value</code> columns</p>
  <p><code>key</code> has different values and that values stores data in <code>value</code>column</p>
  <p>Example:</p>
  <pre><code>**key**               **value**
  car_name              Honda
  car_color             black
  car_name              Audi
  car_color             white
  ....                  .....
  ....                  .....
  </code></pre>
  <p>I am able to select all car names or car colors</p>
  <pre><code>SELECT DISTINCT(value) as name FROM `cars` WHERE key = 'car_name';
  SELECT DISTINCT(value) as color FROM `cars` WHERE key = 'car_color';
  </code></pre>
  <p>BUT, how can I combine these two values?</p>
  <p><strong>E.g</strong></p>
  <p>if <code>car_name = Honda</code> show only colors that Honda has in DB stored as <code>car_color</code> (in example case it would be black)</p>
  <p><strong>Current output</strong></p>
  <p>showing of course all the values under <code>car_color</code> (in example case it would be black, white)</p>
  <p>Is it possible to combine these two keys/values?</p>