title: MyBatis 'or' criteria
body: <pre><code>select
      *
  from person
  WHERE (id like '%test%'
     or name like '%test%' 
      or location like '%test%'
   )
   and date &gt;= '2019-10-24 00:00:00'
   and date &lt; '2019-10-26 00:00:00' 
  </code></pre>
  
  <p>How could I construct that with Criteria objects?</p>
  
  <pre><code>MyExample example = new MyExample();
  MyExample.Criteria criteria = example.createCriteria();
  </code></pre>