concat中的concat mysql

Question

假设我有一张这样的桌子

+-----+---------------+
| id  |     name      |
+-----+---------------+
|   1 | Meatball 300g |
+-----+---------------+

如何使url列的格式为> myurl.com/id product/name (但用“-”分隔)

所以根据预期的结果，应该是这样的

+-----+---------------+---------------------------+
| id  |     name      |            url            |
+-----+---------------+---------------------------+
|   1 | Meatball 300g | myurl.com/1/Meatball-300g |
+-----+---------------+---------------------------+

我试着这样做，但是我不知道concat里面有concat

SELECT CONCAT_WS("/","myurl.com",id,CONCAT(dont know if this format concat was right)) AS url

Answer 1

对字符串字面值使用单引号，我认为您需要：

SELECT id, name, CONCAT_WS('/', 'myurl.com', id, REPLACE(name, ' ', '-')) AS url
FROM yourTable;