title: automate process to avoid manual update of a column in sql
body: <p>i have a table like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>city</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Emma</td>
  <td>Athens</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>Berlin</td>
  </tr>
  <tr>
  <td>Emma</td>
  <td>Athena</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>Berlins Germany</td>
  </tr>
  <tr>
  <td>Emma</td>
  <td>Athena-Greece</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>228 Street, Berlin</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>in which i'm trying to change the value of a column city like:
  where city like '%Athen%' to be updated as 'Athens'
  and city like '%Berlin%' updated to 'Berlin'</p>
  <p>i tried to find a solution using replace, ex:</p>
  <pre><code>select replace(city, '%Athen%', 'Athens') 
  from person
  where city like '%Athen%'
  </code></pre>
  <p>but it doesn't work.</p>
  <p>the result of the table should be that:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>city</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Emma</td>
  <td>Athens</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>Berlin</td>
  </tr>
  <tr>
  <td>Emma</td>
  <td>Athens</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>Berlin</td>
  </tr>
  <tr>
  <td>Emma</td>
  <td>Athens</td>
  </tr>
  <tr>
  <td>Edie</td>
  <td>Berlin</td>
  </tr>
  </tbody>
  </table>
  </div>