title: Copy rows from source table to new table given condition
body: <p>I use the following code but the program gives out an error and does not work:</p>
  
  <pre><code>INSERT INTO dest
  SELECT *
  FROM source
  WHERE source.var="value";
  </code></pre>
  
  <p>I want to copy all rows and columns from the source table into the destination table given a condition. How do I solve this?</p>