title: How to replace all occurrences of a string in SQL
body: <p>I have a data as follows</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Names</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>0002_○●○; B0024_○●;</td>
  </tr>
  <tr>
  <td>0032_●○; 0041_○●○; D0030_○●;</td>
  </tr>
  <tr>
  <td>022_○●●; A0071_○●; 0080_●●○; C0150_○○○;</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>○● is a non-English name</p>
  <p>I hope to get the following result</p>
  <pre><code>○●○; ○●; 
  ●○; ○●○; ○●; 
  ○●●; ○●; ●●○; ○○○; 
  </code></pre>
  <p>I try to use replace to replace English, numbers, symbols</p>
  <pre><code>select REPLACE(Names, '%[^A-Za-z0-9]%', '')
  from test
  </code></pre>
  <p>But it didn't work</p>
  <p>How can I modify it?</p>
  <p>Thank you</p>