Error Unexpected token '%' : JPQL - LIKE %FUNCTION(:namedParam)%

Question

I get Unexpected token '%' when use this JPQL query: In my case I use the upper function but it could be anyone.

@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE %UPPER(:asunto)% ")
public Entity namedMethod(@Param("asunto") String asunto));

I need to add LIKE %:param% to find any coincidence of the param inside my text.

Have tried :

@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE '%'UPPER(:asunto)'%' ")

Unexpected token: UPPER

@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE '%UPPER(:asunto)%' ")

Unexpected token: UPPER

No luck in there either.

Thanks in advance.

[JPQL Concat operator](https://stackoverflow.com/questions/8504457/jpa-concat-operator) — M. Prokhorov, Feb 22 '18 at 11:22
Possible duplicate of [JPQL Like Case Insensitive](https://stackoverflow.com/questions/37178520/jpql-like-case-insensitive) — lcnicolau, Jun 24 '18 at 20:40

UHDante · Accepted Answer · 2018-06-25T06:41:18.217

5

Solved, there are two ways to resolve this problem:

@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE '%' || UPPER(:asunto) || '%' ")

@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE CONCAT('%', CONCAT(UPPER(:asunto),'%')) ")
EDIT-- Thanks to @Nicolau: 
@Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE UPPER(CONCAT('%',:asunto,'%'))")

Both works!

Thanks to @M.Prokhorov.

edited Jun 25 '18 at 06:41

answered Feb 22 '18 at 11:44

UHDante

577
9
21

1

Simpler: @Query("SELECT s FROM Entity s WHERE UPPER(s.asunto) LIKE UPPER(CONCAT('%',:asunto,'%'))") – lcnicolau Jun 24 '18 at 20:47

Error Unexpected token '%' : JPQL - LIKE %FUNCTION(:namedParam)%

1 Answers1