1
Does anyone know how I can use any clause similar to WHERE IN
in the spring jpa
?
example:
@Modifying
@Transactional
@Query(value = "Delete from table where id in(:ids)",nativeQuery=true)
void deleteByIdid(@Param("ids") String var);
I’ve tried to send a String
similar to this:
5151,5151,51515,884,8484.
But it doesn’t work.
Message
couldn't execute statement.
I believe it’s time to pass the spring
puts the variável
in quotes.
that’s exactly what I needed, thank you.
– Roberto Oliveira
@Robertooliveira happy to help! You can mark the answer as correct? :)
– Danilo Gomes
@Robertooliveira can mark the answer as correct?
– durtto