# PROCEDIMIENTO QUE SEGUN LA ENTRADA (VALOR ALPHA [1-4] COLUMNA, CONDICION) RETORNA EL VALOR
DROP PROCEDURE IF EXISTS GET_ALPHA;

DELIMITER $$
CREATE PROCEDURE `GET_ALPHA`(IN FieldNameValue INT, IN FieldValue INT)
BEGIN
    IF FieldNameValue = 1 THEN
        SELECT * FROM bbdd_global.model_peru WHERE alpha1 = FieldValue ORDER BY table_name;
    ELSEIF FieldNameValue = 2 THEN
        SELECT * FROM bbdd_global.model_peru WHERE alpha2 = FieldValue ORDER BY table_name;
    ELSEIF FieldNameValue = 3 THEN
        SELECT * FROM bbdd_global.model_peru WHERE alpha3 = FieldValue ORDER BY table_name;
    ELSEIF FieldNameValue = 4 THEN
        SELECT * FROM bbdd_global.model_peru WHERE alpha4 = FieldValue ORDER BY table_name;
    END IF;
END$$
DELIMITER ;

CALL GET_ALPHA(3, 1);