title: Mysql query to replace name based on id of another table
body: <p>i have two tables clients and well_names</p>
  
  <p><strong>Table Clients</strong></p>
  
  <pre><code>id,name
  1   ABC
  2   TEST
  3   XYZ
  </code></pre>
  
  <p><strong>Table well_names</strong></p>
  
  <pre><code>id,operator
  1   ABC
  2   ABC
  3   ABC
  4   TEST
  5   TEST
  6   XYZ
  7   XYZ
  </code></pre>
  
  <p>I want to select id from clients tables and update on operator column in well_names table.</p>
  
  <p><strong>Expected output</strong></p>
  
  <p>Table well_names</p>
  
  <pre><code>id,operator
  1   1
  2   1
  3   1
  4   2
  5   2
  6   3
  7   3
  </code></pre>