title: How to apply like query in JpaRepository on List of String
body: <p>I am using JpaRepository and I am trying to query into DB using <code>List&lt;String&gt;</code> so I am using like query for the same and I am not getting any results.</p>
  <p>Here is my query:</p>
  <pre><code>@Query(&quot;SELECT a FROM MappingEntity a WHERE UPPER(a.cuisines) LIKE (% :cuisine_type %) AND ST_distance(ST_POINT(:lng , :lat), a.geoLocation) &lt; :radius&quot;)
  List&lt;OpentableMappingEntity&gt; getRestaurantsListCuisines1(@Param(&quot;cuisine_type&quot;) List&lt;String&gt; cuisines, @Param(&quot;lat&quot;) double latitude, @Param(&quot;lng&quot;) double longitude, @Param(&quot;radius&quot;) Integer radius);
  
  @Query(&quot;SELECT a FROM MappingEntity a WHERE UPPER(a.cuisines) LIKE CONCAT('%', CONCAT(:cuisine_type, '%')) AND ST_distance(ST_POINT(:lng , :lat), a.geoLocation) &lt; :radius&quot;)
  List&lt;OpentableMappingEntity&gt; getRestaurantsListCuisines2(@Param(&quot;cuisine_type&quot;) List&lt;String&gt; cuisines, @Param(&quot;lat&quot;) double latitude, @Param(&quot;lng&quot;) double longitude, @Param(&quot;radius&quot;) Integer radius);
  </code></pre>
  <p>I tried both the query and I am getting an empty response if I remove the like part it will give me the results.</p>
  <p>How to apply like query on List?</p>