How to use like in mysql select statement.

Sample Code:

create procedure proc_UseLike(
 keyword varchar(20)
)
begin
 SET keyword = CONCAT('%',keyword,'%');
 select * from table1 where field1 like keyword;

end;
call proc_UseLike('romatic');