Simple SELECT SQL statement not working
<pre><code>SELECT user FROM members WHERE admin=1;

SELECT user FROM members WHERE id=1;
</code></pre>

<p>The first query does not work because there's an error in my syntax. The second works but they are virtually identical. Both 'admin' and 'id' are INT(11), but 'id' is the primary key and set to auto-increment. What's wrong here?</p>

<p>The error I receive is:</p>

<blockquote>
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin=1' at line 1</p>
</blockquote>