@Query("SELECT e FROM Employee e WHERE LOWER(e.employeeName) LIKE LOWER(:keyword)")List getByKeyword(@Param("keyword") String keyword);
@Query("SELECT e.employeeName FROM Employee e WHERE e.name CONTAINS :keyword")List findNameContaining(@Param("keyword") String keyword);
@Query("SELECT * FROM Employee WHERE name LIKE :keyword")List findByName(@Param("keyword") String keyword);
@Query("SELECT e FROM Employee e WHERE e.employeeName LIKE CONCAT('%', :keyword, '%')")List searchByName(@Param("keyword") String keyword);