MYSQL´´½¨´æ´¢¹ý³ÌµÄÎÊÌâ(¼±~~~)

Ìáʾ´´½¨±äÁ¿µÄʱºòÓдíÎó
SQL code:

drop procedure if exists proc_novelSearch;
create procedure proc_novelSearch(
in searchType varchar(20), -- ËÑË÷ÀàÐÍ
in searchValue varchar(40), -- ËÑË÷Öµ
in pageItem int, -- Ò³Ïî
in pageIndex int -- Ò³Âë
)
begin
declare sqlStr varchar(250);
set sqlStr = concat('select * from (select * from Novel where ',searchType,' like (%',searchValue,'%) limit 0,',pageItem*pageIndex,') as tempNovel where tempNovel.Id not in(select Id from Novel where ',searchType,' = (%',searchValue,'%) limit 0,',pageItem*(pageIndex-1),'))'
prepare stmtNovelSearch from sqlStr;
execute stmtNovelSearch;
deallocate prepare stmtNovelSearch;
end;

---

SQL code:

drop procedure if exists proc_novelSearch;
create procedure proc_novelSearch(
in searchType varchar(20), -- ËÑË÷ÀàÐÍ
in searchValue varchar(40), -- ËÑË÷Öµ
in pageItem int, -- Ò³Ïî
in pageIndex int -- Ò³Âë
)
begin
declare sqlStr varchar(250);
set sqlStr = concat('select * from
(select * from Novel where ',searchType,' like (%',searchValue,'%) limit 0,',pageItem*pageIndex,') as tempNovel
where tempNovel.Id not in
(select Id from Novel wher