title: Use multiple REGEXP_REPLACE calls in single column for MySQL 8 SELECT statement
body: <h3>Synopsis</h3>
  <p>I would like to use multiple <code>REGEXP_REPLACE</code> function calls in a <code>SELECT</code> statement. The idea is to replace different expressions with different values.</p>
  <p>Using a single call to <code>REGEXP_REPLACE</code> works perfectly fine. Anyone with a first name that doesn't start with <code>T</code> is displayed as <code>NOT TREVOR</code>, and anyone who has a name starting with <code>T</code> is simply displayed as-is.</p>
  <pre><code>DROP DATABASE cbtnuggets;
  CREATE DATABASE cbtnuggets;
  CREATE TABLE IF NOT EXISTS cbtnuggets.people (firstName varchar(30));
  
  INSERT INTO cbtnuggets.people (firstName) VALUES ('Trevor'), ('Daniel'), ('Sally');
  
  SELECT 
    REGEXP_REPLACE(firstName, '^[^T].*', 'NOT TREVOR')
    FROM cbtnuggets.people;
  </code></pre>
  <h3>Problematic Query</h3>
  <p>The following query does not work the way that I would like for it to. Due to the <code>OR</code> statement, the result is a 0 or 1, instead of a string.</p>
  <pre><code>DROP DATABASE cbtnuggets;
  CREATE DATABASE cbtnuggets;
  
  CREATE TABLE IF NOT EXISTS cbtnuggets.people (firstName varchar(30));
  
  INSERT INTO cbtnuggets.people (firstName) VALUES ('Trevor'), ('Daniel'), ('Sally');
  
  SELECT 
    REGEXP_REPLACE(firstName, '^[^T].*', 'NOT TREVOR')
    OR REGEXP_REPLACE(firstName, '^T', 'This is Trevor')
    FROM cbtnuggets.people;
  </code></pre>
  <h3>Expected Result</h3>
  <p>I would like to return different values for different expressions in a single <code>SELECT</code> statement (if possible), using the <code>REGEXP_REPLACE</code> function.</p>
  <h3>Question</h3>
  <p>Is there any way to handle this desired result in a select statement, or would I need to create a MySQL function to handle these multiple expressions?</p>