title: Logical AND operator in mySql REGEXP?
body: <p>I use MySql REGEXP:</p>
  
  <pre><code>SELECT * FROM myTable
  WHERE title REGEXP "dog|cat|mouse";
  </code></pre>
  
  <p>The dataset is small, so I am not concerned about performance.  And I prefer this over LIKE notation, because I do not have to concatenate a bunch of "LIKE" statements.</p>
  
  <p>However, the above notation uses a logical OR operator.  Is there a logical AND operator, so that only rows containing all of the keywords are matched?</p>
  
  <p>(I am using InnoDB so fulltext search not an option)</p>