DROP PROCEDURE IF EXISTS `search_product`;
DELIMITER ;;
CREATE PROCEDURE `search_product` (
    IN search_product VARCHAR(100)
)
proc:BEGIN
    SELECT product_name
    FROM products
    WHERE product_name LIKE CONCAT('%', search_term, '%');
END ;;
DELIMITER ;