By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE loan_user (
id long,
amount long
);
INSERT INTO loan_user(id, amount)
values (1,7000), (2,7000), (3,5000);
CREATE PROCEDURE loan_check(OUT _answer BIGINT)
BEGIN
DECLARE a int;
select count(amount) into a from loan_user where amount=7000;
SET _answer = a;
END
SET @answer := 0;
CALL loan_check(@answer);
SELECT IF(@answer = 2, 'yes',@answer)as answer
| answer |
|---|
| yes |