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