title: SQL Insert Query With Condition
body: <p>I am trying to insert values into 1 column of a table when a condition is satisfied. </p>
  
  <p>Note: The table already contains data for all the columns but for 1 which is empty. I would like to insert value into this 1 column depending on the WHERE clause. </p>
  
  <p>I have this query:</p>
  
  <pre><code>INSERT INTO &lt;TABLE_NAME&gt;
  (COLUMN_NAME)
  (VALUE)
  WHERE &lt;CONDITION&gt;
  </code></pre>
  
  <p>I am  getting an exception: </p>
  
  <blockquote>
    <p>Incorrect Syntax Near WHERE Keyword</p>
  </blockquote>
  
  <p>I am able to do this using UPDATE:</p>
  
  <pre><code>UPDATE &lt;TABLE_NAME&gt;
  SET &lt;COL_NAME&gt;
  WHERE &lt;CONDITION&gt;
  </code></pre>
  
  <p>But was wondering why the INSERT query was failing. Any advise appreciated. </p>