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()
BEGIN
DECLARE a int;
select count(amount) from loan_user where amount=7000;
END
CALL loan_check();
| count(amount) |
|---|
| 2 |
CREATE PROCEDURE loan_check2(_inc int)
BEGIN
DECLARE a int;
select IF(count(amount) = 2 , 'yes',COUNT(amount)) as answer from loan_user where amount=_inc;
END
CALL loan_check2(7000);
| answer |
|---|
| yes |