title: SQL syntax error near WHERE clause
body: <p>Can anyone tell me what's wrong in this query?</p>
  
  <pre><code>&lt;cfquery name="activesurveys"&gt;
        SELECT surveys.id,
               surveys.name,
               surveys.description,
        WHERE  surveys.active= 1
          AND  surveys.showinpubliclist= 1
       FROM 
               surveys
  &lt;/cfquery&gt;
  &lt;cfreturn activesurveys&gt;
  </code></pre>
  
  <p>When I execute this code it gives this error:</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 'WHERE surveys.active= 1 AND surveys.showinpubliclist= 1' at line
    4"</p>
  </blockquote>