CREATE DEFINER=`root`@`%` FUNCTION `get_count_nonfunctional`(str1 VARCHAR(50) CHARSET utf8mb4 COLLATE 'utf8mb4_0900_ai_ci',str2 VARCHAR(50) CHARSET utf8mb4 COLLATE 'utf8mb4_0900_ai_ci') RETURNS int
BEGIN
 
  DECLARE cnt INT(10) DEFAULT 0;
  SELECT count(*) into cnt FROM mytable WHERE n1=str1 and n2=str2;
  RETURN (cnt);
	
END