spring data jpa中@Query中的模糊查询 like 关键字

 @Query(value="select * from search_key a where a.key_name like CONCAT('%',:keyName,'%') limit 1",nativeQuery=true)
  List<SearchKey> findByKeyNameLimit(@Param("keyName") String keyName);

public interface DeviceRepository extends JpaRepository<Device, Long>, JpaSpecificationExecutor<Device> {

    List<Device> findByUserId(Long id);

    @Query(value = "select * from biz_device where create_time like CONCAT('%',:time,'%') order by ?#{#pageable}", nativeQuery = true)
    Page<Device> findByCreateTimeLike(@Param("time")String time,Pageable pageable);

}