pro-select-like

 1 DELIMITER |
 2 drop procedure if exists pro_query;
 3 CREATE  PROCEDURE pro_query 
 4 ( 
 5     cname VARCHAR(50)
 6 )  
 7 BEGIN  
 8   
 9 #declare @sql varchar(1000)
10 
11 SELECT * ,cname FROM test WHERE (cname ="" or name like CONCAT('%',cname,'%') );
12 
13 END;
14 |
15 DELIMITER ;
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/a9999/p/7002139.html