title: JPA query IN clause on column with CSV values not returning exact results
body: <p>I'm working on a JPA query where I need to get the correct results.</p>
  
  <p>Table structure (let's call this <strong>T1</strong>):</p>
  
  <p><a href="https://i.stack.imgur.com/A6s4a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A6s4a.png" alt="enter image description here"></a></p>
  
  <p>and this is my JPA query:</p>
  
  <pre><code>@Query("from T1 t where t.csv in :ids")
  List&lt;T1&gt; listT1Records(@Param("ids") List&lt;String&gt; ids);
  </code></pre>
  
  <p>The csv column can also contain non-numeric string. when I query using raw sql it returns records <strong>1</strong>,<strong>2</strong> and <strong>3</strong> which is my desired result but when I debugged my code the returned result is only record <strong>2</strong>. I looked up everywhere for answers but found none.</p>
  
  <p>Raw Sql</p>
  
  <pre><code>select * from T1 where csv in (11);
  </code></pre>