 <p>You can try some like this basic structure</p> <pre><code>INSERT INTO temp_table (Value1,Value2,Value3) SELECT field1, field2, field3 FROM the_table WHERE condition_value = some_value </code></pre> <p>Remember have the same number of fields in your <code>INSERT INTO</code> and your <code>SELECT</code>. </p>