title: How can I update all the records that match my SELECT query in SQL?
body: <p>I need to change the <strong>post_status</strong> field for all the records from February 2017 in a particular table to <em>wc-pending</em></p>
  
  <p>I have figured out how to select all those records:  </p>
  
  <pre><code>SELECT * FROM `wp_posts` WHERE `post_title` LIKE '%FEB%2017%'
  </code></pre>
  
  <p>And I <em>think</em> this will change the field as I need to:</p>
  
  <pre><code>SET post_status='wc-pending'
  </code></pre>
  
  <p>But I am stumped on how to put these two together to update the post_status fields for only those records that match the SELECT query.</p>
  
  <p>My hunch is that the following might do it if I execute it while in that table</p>
  
  <pre><code>SET post_status='wc-pending' WHERE `post_title` LIKE '%FEB%2017%'
  </code></pre>
  
  <p>Does that seem correct?
  Any guidance is appreciated. I am totally new to SQL. Thanks!</p>