mysql 分解url

-- 创建表结构
CREATE TABLE url_parts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    protocol VARCHAR(10),
    host VARCHAR(255),
    path VARCHAR(255),
    query_params TEXT
);

-- 插入数据
INSERT INTO url_parts (protocol, host, path, query_params)
VALUES ('http', 'www.example.com', '/path/to/resource', 'key=value&foo=bar');

-- 查询数据
SELECT * FROM url_parts;

from urllib.parse import urlparse

url = 'http://www.example.com/path/to/resource?key=value&foo=bar'
parsed_url = urlparse(url)

protocol = parsed_url.scheme
host = parsed_url.netloc
path = parsed_url.path
query_params = parsed_url.query

print(f'Protocol: {protocol}')
print(f'Host: {host}')
print(f'Path: {path}')
print(f'Query Params: {query_params}')

SELECT * FROM url_parts WHERE host = 'www.example.com';