title: Replace/Update multiple field values into a single value using sql
body: <p>my table is like:</p>
  
  <pre><code>id |  name |   subject
  -------------------
  1  | kil   |   btech
  2  | Jim   |   BACHELOR OF TECHNOLOGY
  3  | Joe   |   Btech
  4  | Ruth  |    MCA
  5  | priya |   Master in comp application
  6  | dev   |   MASTER IN COMPUTER APPLICATION
  7  | sen   |   Master in Computer Application
  </code></pre>
  
  <p>how to group related field value into a single name such as:</p>
  
  <pre><code>id |  name  |  subject
  -------------------
  1  | kil    |  BACHELOR OF TECHNOLOGY
  2  | Jim    |  BACHELOR OF TECHNOLOGY
  3  | Joe    |  BACHELOR OF TECHNOLOGY
  4  | Ruth   |  Master in Computer Application
  5  | priya  |  Master in Computer Application
  6  | dev    |  Master in Computer Application
  7  | sen    |  Master in Computer Application
  </code></pre>