title: Combine INSERT with SELECT statement with custom values
body: <p>I need to clean up my MySQL database and make a lot of new records based on the current state.
  I need to insert this:</p>
  
  <pre><code>INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES ($ID, "price_input_currency", "usd")
  </code></pre>
  
  <p>For each $ID I get from this selection:</p>
  
  <pre><code>SELECT ID FROM wp_posts AS posts
  RIGHT JOIN wp_postmeta ON posts.ID = post_id
  WHERE post_type = 'post'
  AND meta_value LIKE '%$%' AND meta_key = 'price_range'
  </code></pre>
  
  <p>Is this possible through only a MySQL code?
  I've seen a bunch of "how to combine INSERT with SELECT, but none of them used just strings to insert, they always SELECTED ALL the fields they needed to insert...
  Any ideas?</p>