title: Search like sql using '%' criteria native sql
body: <p>I have a code to connect <em>PL/SQL</em> search like using '%' and I use criteria to implement</p>
  <pre><code>String sql = &quot;SELECT * FROM EMPLOYEE &quot;;
  Query query = entityManager.createNativeQuery(sql.toString());
  
  if(searchCharacterInfo.getKeyword() != null){
        sql += &quot; WHERE NAME LIKE %:keyword% &quot;;
        query = entityManager.createNativeQuery(sql).setParameter(&quot;keyword&quot;, keyword);
  }
  
  List&lt;Object&gt; res =  query.getResultList();
  return res;
  </code></pre>
  <p>When I run this code to show error:</p>
  <pre><code>Could not locate named parameter keyword
  </code></pre>
  <p>Please help me solve this problem!</p>