title: creating Spring Repository Select using multiple "like" and Pageable
body: <p>I'm using H2-Database and Spring-Data PagingRepository. I like to use paging and select all <em>articles</em> from database that field <em>html</em> contains <em>'@'</em> or <em>'[at]'</em> or <em>'(at)'</em> or <em>'mail'</em> ...</p>
  
  <p>So the native query without paging looks like</p>
  
  <pre><code>SELECT * FROM article  WHERE (html LIKE '%@%' or html LIKE '%(at)%' or html LIKE '%[at]%' or ...)
  </code></pre>
  
  <p>I tried to solve it like this:</p>
  
  <pre><code>Page&lt;Article&gt; findByHtmlContainingOrderByDateDesc(String[] string,  Pageable pageable);
  </code></pre>
  
  <p>But there is no/empty result.</p>
  
  <p>Second way I tried is using a native query:</p>
  
  <pre><code>@Query(value = "SELECT * FROM article  WHERE (html LIKE '%@%' or html LIKE '%(at)%') ORDER BY DATE desc \n#pageable\n" , 
  nativeQuery = true,
  countQuery = "SELECT count(*) FROM article  WHERE (html LIKE '%@%' or html LIKE '%(at)%')")
  Page&lt;Article&gt; findAll(@Param("pageable") Pageable pageable);
  </code></pre>
  
  <p>But I'm getting the exception:</p>
  
  <p><em>nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement] with root cause</em></p>
  
  <p>Thanks a lot for help!</p>