'Why use SpringJpa paging query to report SQL syntax errors?

enter image description here

When I used SpringJpa to implement paged queries I got a syntax error but I don't know what it was, if you put quotes around it you can't query the data.

spring-boot

Solution 1:^[1]

Try this:

Change like %?% to like %?1%

or like CONCAT('%',?,'%')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	paranaaan

'Why use SpringJpa paging query to report SQL syntax errors?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]