在mysql中:
select * from table_name where name like concat('%',#name#,'%');
在oracle中:
select * from table_name where name like '%'||#name#||'%';
在SQL Server中:
select * from table_name where name like '%'+#name#+'%';
SQL Server:select * from stu where name like '%'+#name #+'%