CONCAT关键字,拼接字符串,例:
@Select("SELECT * FROM classify WHERE itemName like CONCAT('%',#{itemName},'%');")
public List<Classify> getClassifyHaveName(String itemName);
CONCAT关键字,拼接字符串,例:
@Select("SELECT * FROM classify WHERE itemName like CONCAT('%',#{itemName},'%');")
public List<Classify> getClassifyHaveName(String itemName);