mysql存储过程中模糊查询语句拼接问题
[code="java"]set @stmt=concat('select * from jargon where name like \'%',ucase(t),'%\' or memo like \'%',ucase(t),'%\' order by id desc limit ',snum,',',size);
prepare stmt from @stmt;
execute s...
2010-09-20 14:04:42 ·
710 阅读 ·
0 评论