sql语句:
SELECT user.id WHERE JSON_EXTRACT ( user.ext_obj, '$.type' ) = 1
jpa写法:
predicateList.add(criteriaBuilder.equal( criteriaBuilder.function( "JSON_EXTRACT", String.class, root.get("extObj"), criteriaBuilder.literal("$.type") ), 1)
sql语句:
SELECT user.id WHERE JSON_EXTRACT ( user.ext_obj, '$.type' ) = 1
jpa写法:
predicateList.add(criteriaBuilder.equal( criteriaBuilder.function( "JSON_EXTRACT", String.class, root.get("extObj"), criteriaBuilder.literal("$.type") ), 1)