title: MySQL string contains string
body: <p>I am using MySQL Workbench and I'm currently looking for a function or something that helps me check if a string is within another string.
  For example: </p>
  
  <p><code>text1 = 'hello , name , world';</code></p>
  
  <p>If I have a string or <code>varchar</code> that is something like this </p>
  
  <p><code>'My name is'</code></p>
  
  <p>It should say that it contains since it has 'name' on it.
  Basically what I'm trying to do is I have a Comments table and I'm creating a trigger before insert on Comments that checks if the <code>comment_text</code> contains any swear words. These swear words are saved like this</p>
  
  <blockquote>
    <p>select group_concat(word) into texto from reserved_words;</p>
  </blockquote>
  
  <p>So it has all the words close to each other: swear1,swear2,swear3,etc</p>
  
  <p>I want it to update a certain table if the comment really contains a swear word.
  I've tried to use <code>LIKE, SUBSTR(),CONTAINS(),REGEXP</code> without any success.</p>
  
  <p>Can someone help?</p>