如何在JPA规范中使用mysql "json_contains“

@Entity
@Table(name = "your_table_name")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(columnDefinition = "json")
    private String jsonData;

    // Getters and setters
}

@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
    @Query(value = "SELECT * FROM your_table_name WHERE JSON_CONTAINS(json_data, :jsonValue)", nativeQuery = true)
    List<YourEntity> findByJsonDataContains(@Param("jsonValue") String jsonValue);
}

@Service
public class YourService {
    @Autowired
    private YourRepository yourRepository;

    public List<YourEntity> findByJsonDataContains(String jsonValue) {
        return yourRepository.findByJsonDataContains(jsonValue);
    }
}