title: REGEXP match either keywords in the string using MySQL
body: <p>I am trying to search for a keyword in the string using REGEXP, how I want to search is:</p>
  
  <p>Stored String 1: "The quick brown fox jumps over the lazy dog"
  Stored String 2: "The clever rabbit ran away from the tiger"
  Keywords: "Clever| Fox"  (The two keywords separated by the delimiter "|") </p>
  
  <p>I want to search for a stories which contains the either one of the keywords or all of the keywords.</p>
  
  <p>I used str_replace the keyword string to make a keyword string a regular expression that can be used in mysql query. I tried many solutions which are provided here to previously asked questions but I found nothing working for me.</p>
  
  <p>One of what I have tried so far is this:</p>
  
  <pre><code>SELECT * FROM stories WHERE story_body REGEXP '[[:&lt;:]]Clever[[:&gt;:]].*[[:&lt;:]] Fox[[:&gt;:]]'
  </code></pre>
  
  <p>How do I achieve this? Thanks!</p>