SQL Key value table--select ids that have multiple keys
<p>I need to obtain records in a key-value table with the following structure:</p>

<pre><code>CREATE TABLE `PROPERTY` (
  `id` int(11) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`,`key`)
);
</code></pre>

<p>I need to get all ids that have MULTIPLE specific key-value entries. For example, all ids that have keys "foo", "bar", and "foobar".</p>