DELIMITER $$
DROP PROCEDURE IF EXISTS `updateAllOtherInsurance`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `updateAllOtherInsurance`(pIDs VARCHAR(1000))
BEGIN
DELETE FROM patientinsuranceelgihistory WHERE FIND_IN_SET(patientInsID, pIDs) > 0;
END$$
DELIMITER ;