--create a procedre CREATE DEFINER='root'@'localhost' PROCEDURE 'sp_compall'(name varchar(50)) begin if name='' then select * from eb_comp; else select * from eb_comp where companyname like name; end if; end;