I have a query in spring boot that works as jpql:
@Query("SELECT new Kindergarten(k.id, k.name , k.address, k.elderate, k.capacityAgeGroup2to3, k.capacityAgeGroup3to6)
FROM Kindergarten k WHERE LOWER(k.name) LIKE LOWER(concat('%', ?1,'%'))")
What does it mean those three things: concat('%', ?1,'%') ?
Interesting is that this works and find and Kindergarten name what you enter. It finds the most similar to the one you print.
But how exactly does it work?
I want to understand how those three wildcards do the magic. What is the meaning of it?
Some theory: https://www.w3schools.com/Sql/sql_like.asp