title: Android Room - Select query with LIKE
body: <p>I'm trying to make a query to search all objects whose names contain text:</p>
  <pre><code>@Query(&quot;SELECT * FROM hamster WHERE name LIKE %:arg0%&quot;)
  fun loadHamsters(search: String?): Flowable&lt;List&lt;Hamster&gt;&gt;
  </code></pre>
  <p>Messages:</p>
  <pre><code>Error:no viable alternative at input 'SELECT * FROM hamster WHERE name LIKE %'
  Error:There is a problem with the query: [SQLITE_ERROR] SQL error or missing database (near &quot;%&quot;: syntax error)
  Error:Unused parameter: arg0
  </code></pre>
  <p>Also, I'm trying:</p>
  <pre><code>@Query(&quot;SELECT * FROM hamster WHERE name LIKE '%:arg0%'&quot;)
  fun loadHamsters(search: String?): Flowable&lt;List&lt;Hamster&gt;&gt;
  </code></pre>
  <p>Messages:</p>
  <pre><code>Error:Unused parameter: arg0
  </code></pre>
  <p>How to fix this?</p>