title: Do an update without knowing the ID
body: <p>I have this request:</p>
  
  <pre><code>UPDATE PEOPLE SET ID_STATE = 5 WHERE ID_STATE IN (3,4);
  </code></pre>
  
  <p>I would make the same request but if I do not know the <code>ID_STATE</code> but just the <code>labelStatePeople</code></p>
  
  <pre><code>SELECT ID_STATE FROM STATE_PEOPLE WHERE labelStatePeople = 'blue';
  </code></pre>
  
  <p><strong><em>EXAMPLE:</em></strong></p>
  
  <pre><code>$1 = SELECT ID_STATE FROM STATE_PEOPLE WHERE labelStatePeople = 'blue';
  $2 = SELECT ID_STATE FROM STATE_PEOPLE WHERE labelStatePeople = 'yellow';
  $3 = SELECT ID_STATE FROM STATE_PEOPLE WHERE labelStatePeople = 'red';
  </code></pre>
  
  <p><strong><em>final request:</em></strong> <code>UPDATE PEOPLE SET ID_STATE = $1 WHERE ID_STATE IN ($2,$3);</code></p>