title: SELECT REPLACE Multiple Cases of the Same Value in MySQL
body: <p>I know that SELECT REPLACE can replace one case of a string but I am trying to replace multiple cases with the same string and I haven't found an example of how to do this.</p>
  
  <p>I have a table:</p>
  
  <pre><code>+--------------+
  | station_name |
  +--------------+
  | WABC-FM      |
  | WXYZ-G2      |
  | WWWW-H2      |
  | WWAS-A2      |
  | WFRE-A3      |
  | WRES-AM      |
  +--------------+
  </code></pre>
  
  <p>What I'd like is a bit complicated. I'll use the normal SELECT REPLACE to try to explain what I'm looking for.</p>
  
  <p>Basically, every instance of G2 or H2 needs to be replaced with FM and every intance of A2 or A3 with AM.</p>
  
  <p>So something like <code>SELECT REPLACE(station_name, ['G2', 'H2'], 'FM')</code> combined with another <code>SELECT REPLACE(station_name, ['A2', 'A3'], 'AM')</code></p>