Translate function Oracle to Mysql

Hi, I have this function in Oracle, how could I migrate it to mysql? I understand that the syntax is similar but this function does not find it familiar.

Thank you

FUNCTION F_GET_TABLE_NAME(TABLE_NAME VARCHAR2, COL1 VARCHAR2, COL2 VARCHAR2,CHOICECOL NUMBER, GROUP_CD VARCHAR2, STAT_FLAG VARCHAR2) RETURN VARCHAR2 IS
TMPVAR VARCHAR2(70);
TMPSQL VARCHAR2(300);
BEGIN
    TMPVAR := NULL;

    IF GROUP_CD != 'N' THEN
        IF STAT_FLAG != 'N' THEN
            TMPSQL := 'SELECT  '||COL2||' FROM '||TABLE_NAME||'  WHERE '||COL1||' = '''||CHOICECOL||''' AND GROUP_CD = '''||GROUP_CD||''' AND STAT_CD = ''1000'' ORDER BY  '||COL2;
        ELSE
            TMPSQL := 'SELECT  '||COL2||' FROM '||TABLE_NAME||'  WHERE '||COL1||' = '''||CHOICECOL||''' AND GROUP_CD = '''||GROUP_CD||''' ORDER BY  '||COL2;                
        END IF;

    ELSE
        IF STAT_FLAG != 'N' THEN
            TMPSQL := 'SELECT  '||COL2||' FROM '||TABLE_NAME||'  WHERE '||COL1||' = '''||CHOICECOL||''' AND STAT_CD = ''1000'' ORDER BY  '||COL2;
        ELSE
            TMPSQL := 'SELECT  '||COL2||' FROM '||TABLE_NAME||'  WHERE '||COL1||' = '''||CHOICECOL||''' ORDER BY  '||COL2;                
        END IF;

    END IF;

    EXECUTE IMMEDIATE TMPSQL INTO TMPVAR;

    RETURN TMPVAR;

    EXCEPTION
        WHEN NO_DATA_FOUND THEN return '';
        WHEN OTHERS THEN return 'CODE ERROR';
END;