title: After Search in SQL Update a column value in the found rows
body: <p>I have a DB table where a Field can have several different values, I want to update a field with certain values please see table below</p>
  
  <pre><code>ID  Name1   Place   Number
  1   Key     TR       3
  2   Lock    BG       45
  3   Turn    GH       67
  4   Key     KL       89
  </code></pre>
  
  <p>I would like to change the Name1 fields containing Key with Keys2. My actual table has more than 100 rows so I don't want to just look for the ID and then replace it.</p>
  
  <p>The search part is not a problem I can do that as follows:</p>
  
  <pre><code>Search * tableX where 'Name1' = 'Key'
  </code></pre>
  
  <p>So this would find the rows with ID 1 and 4. The I would like to update these found rows so the table now looks like</p>
  
  <pre><code>ID  Name1   Place   Number
  1   Key2    TR      3
  2   Lock    BG      45
  3   Turn    GH      67
  4   Key2    KL      89
  </code></pre>
  
  <p>I would not know where to start to update all of found rows. any help is welcome</p>