<p>I'm trying to do this</p>

<pre><code>SELECT `Name`,`Value` FROM `Constants` 
WHERE `Name` NOT IN ('Do not get this one'|'or this one');
</code></pre>

<p>But it doesn't seem to work.</p>

<p>How do I get all the values, except for a select few, without doing this:</p>

<pre><code>SELECT `Name`,`Value` FROM `Constants` 
WHERE `Name` != 'Do not get this one' 
AND `Name` != 'or this one'
</code></pre>

<p>The first one works with int values, but doesn't work with varchar, is there a syntax like the first one, that performs like the second query?</p>

It's
```
IN('foo', 'bar')
```
, with a comma, not a pipe.