CREATE PROCEDURE `pharm_get_drug_search`(IN `query_type` VARCHAR(100), IN `facId` VARCHAR(50), IN `in_from` INT, IN `in_to` INT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER SELECT * FROM `pharm_store` WHERE drug_name like query_type AND facilityId = facId LIMIT in_from, in_to;