mysql 截取url参数

-- 创建示例表
CREATE TABLE urls (
    id INT AUTO_INCREMENT PRIMARY KEY,
    url VARCHAR(255) NOT NULL
);

-- 插入示例数据
INSERT INTO urls (url) VALUES ('https://example.com/path?param1=value1&param2=value2');

-- 使用 SUBSTRING_INDEX 函数提取 param1 的值
SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX(url, 'param1=', -1), '&', 1) AS param1_value
FROM 
    urls;

SELECT 
    URL_DECODE(SUBSTRING_INDEX(SUBSTRING_INDEX(url, 'param1=', -1), '&', 1)) AS param1_value
FROM 
    urls;

SELECT 
    CASE 
        WHEN url REGEXP '^https?://.*$' THEN 
            SUBSTRING_INDEX(SUBSTRING_INDEX(url, 'param1=', -1), '&', 1)
        ELSE 
            'Invalid URL'
    END AS param1_value
FROM 
    urls;