mysql写法:like %:参数%,具体见下图
@Query(value = "select * from base_area where pcodes like %:pcodes% ", nativeQuery = true)
List<Area> findByIsDeletedAndPcodesLike(@Param("pcodes") String pcodes);
oracle写法:like '%'||:参数||'%',具体见下图
@Query(value = "select * from base_area where pcodes like '%'||:pcodes||'%' ", nativeQuery = true)
List<Area> findByIsDeletedAndPcodesLike(@Param("pcodes") String pcodes);