Spring boot JPA @Query中的like和in

@Query("SELECT e FROM Employee e WHERE e.name LIKE %:keyword%")
List<Employee> findByNameContaining(@Param("keyword") String keyword);

@Query("SELECT e FROM Employee e WHERE e.department IN :departments")
List<Employee> findByDepartmentIn(@Param("departments") List<String> departments);

@Query(value = "SELECT e FROM Employee e WHERE e.name LIKE %:keyword% ORDER BY e.id LIMIT :limit", nativeQuery = true)
List<Employee> findByNameContaining(@Param("keyword") String keyword, @Param("limit") int limit);

@Query("SELECT e FROM Employee e WHERE e.department IN :departments")
List<Employee> findByDepartmentIn(@Param("departments") List<String> departments);

@Repository
public interface EmployeeRepository extends JpaRepository<Employee, Long> {

    @Query("SELECT e FROM Employee e WHERE e.name LIKE %:keyword%")
    List<Employee> findByNameContaining(@Param("keyword") String keyword);

    @Query("SELECT e FROM Employee e WHERE e.department IN :departments")
    List<Employee> findByDepartmentIn(@Param("departments") List<String> departments);
}