存储过程中用like接变量

mysql v 5.0.22

 

CREATE  PROCEDURE `p1`(in param integer)begindeclare var1 varchar(20);if param = 1 thenset @var1 = 'qq520';elseset @var1 = 'wunder';end if;set @sqlstr ='select * from _userinfo where uname like ?';prepare stmt from @sqlstr;EXECUTE stmt USING @var1;end;

 接收参数，如果是int类型的1，则like qq520 反之like wunder