title: How to only add specific value to a column?
body: <p>How do I make sure it only concat one value once it already got value?
  For example is the message already got the text "cat", how do I make the "dog" doesnt include?</p>
  
  <pre><code>SELECT name, message,
  
  concat(
  
  if(message like '%cat%', 'cat', ''),
  if(message like '%dog%', 'dog', ''),
  ) as intent
  
  FROM table;
  </code></pre>