求救！存储过程出错

2010-06-05 08:40:50 109 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

保姆级教程：DBeaver社区版安装与驱动配置（附阿里云镜像解决下载超时）本文提供DBeaver社区版的保姆级安装教程，涵盖版本选择、安装路径设置到驱动配置优化。特别针对国内用户遇到的下载超时问题，详细介绍了如何配置阿里云镜像加速驱动下载，确保高效连接MySQL等主流数据库。阅读详情

存储过程代码：

CREATE PROCEDURE so(IN mov char(255),IN p1 int,IN p2 int)   

BEGIN  

SET @sql = CONCAT('SELECT * FROM filedata where title like (%',mov,'%) order by dateandtime desc LIMIT ',p1,',',p2,'');   

PREPARE sqlstmt FROM @sql;   

EXECUTE sqlstmt;   

DEALLOCATE PREPARE sqlstmt;   

END$$

当我调用这个存储过程

call so('nba','1','2');

，MYSQL提示出错：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%nba%) order by dateandtime desc LIMIT 1,2' at line 1

希望各位高手能给指点下迷津，小弟不胜感激！

...全文