mysql查询结果到可点击的url

-- 创建表
CREATE TABLE mytable (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    url VARCHAR(255)
);

-- 插入数据
INSERT INTO mytable (name, url) VALUES ('Google', 'https://www.google.com');
INSERT INTO mytable (name, url) VALUES ('Baidu', 'https://www.baidu.com');

-- 查询结果添加超链接
SELECT CONCAT('<a href="', url, '">', name, '</a>') AS clickable_url
FROM mytable;

+------------------------+
| clickable_url          |
+------------------------+
| <a href="https://www.google.com">Google</a> |
| <a href="https://www.baidu.com">Baidu</a>   |
+------------------------+