mysql預存程序中like用法

CREATE PROCEDURE `proc_init_tagsData`()begin  DECLARE  v_keyword varchar(30);  DECLARE  v_tag_id int default -1;  DECLARE  v_done int;  DECLARE v_count int default 0;-- 定義遊標DECLARE rs_cursor CURSOR FOR select keyword from t_keyword where s_flag=1 order by id limit 15;DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_done=1;open rs_cursor;cursor_loop:loop   FETCH rs_cursor into v_keyword; -- 取資料if(v_count<15)  then  insert into t_tag (name)values(v_keyword);  set v_tag_id = LAST_INSERT_ID();  -- 關鍵是like CONCAT('%',v_keyword,'%'); 這裡的用法  insert into tbl_sm_tag  (tag_id,soft_id) select v_tag_id,id from sm where soft_name like CONCAT('%',v_keyword,'%');end if;set v_count = v_count + 1;     if v_done=1 then    leave cursor_loop;   end if;  end loop cursor_loop;close rs_cursor;