title: Issue with updating a table
body: <p>I have this table</p>
  
  <p><img src="https://i.stack.imgur.com/Luypy.jpg" alt="enter image description here"></p>
  
  <p>What I want to do is that Select the <code>attr_id</code> WHERE a DISTINCT <code>name_en-GB</code> appears and then SET that selected <code>attr_id</code> for that <code>name_en-GB</code></p>
  
  <p>I can do this by writing individual queries but I want to know is there any way I can do this in one query? </p>