Spring JPA Query – JSON_REMOVE – Pass query index dynamically
I'm using JSON_REMOVE method for removing one field from my JSON array column. Below is the query I wrote in JPA - @Modifying @Transactional @Query("UPDATE Data d SET d.month = JSON_REMOVE(d.month, '$[0].revenue') " + " WHERE d.year = :year ")…