Parse Top Level Domain from URL

fn.getTopLevelDomain.sql

DROP FUNCTION IF EXISTS getTopLevelDomain;
DELIMITER ##
CREATE FUNCTION getTopLevelDomain (strURL varchar(1000), level tinyint)
RETURNS varchar(1000)
BEGIN
    IF ISNULL(level) THEN
        SET level = 2;
    END IF;
    IF POSITION('http://' IN strURL) > 0 OR POSITION('https://' IN strURL) > 0
        THEN
        -- Remove not needed stuff
        SET strURL = REPLACE(strURL,'https://','');
        SET strURL = REPLACE(strURL,'http://','');
        SET strURL = REPLACE(strURL,'www.','');

        -- Remove everything after “/” if one exists
        IF POSITION('/' IN strURL) > 0 THEN
            SET strURL = LEFT(strURL,POSITION('/' IN strURL)-1);
        END IF;

        IF LENGTH(strURL) - LENGTH(REPLACE(strURL,'.','')) > (level - 1) then
            set strURL = SUBSTRING_INDEX(strURL, '.', (level * -1));
        end if;

        return strURL;
    END IF;
    return NULL;
END ##
DELIMITER ;