mysql - SQL - 我可以在每列中添加单词吗？

Question

我正在尝试在 mysql 上使用循环或其他任何内容在每一列添加临时单词？当我尝试从玩家中选择 full_name 时。

我可以做类似的事情吗:

+--------------+
|  full_name   |
+--------------+
| Ahmed Sayed  |
+----+------+--+
| **ANY WORD** |
+--------------+
| Kareem Gaber |
+------+-------+
| **ANY WORD** |
+------+-------+
| omar galal   |
+--------------+
| **ANY WORD** |
+------+-------+
| Mohamed gad  |  
+------+-------+
| **ANY WORD** |
+--------------+

Answer 1

您可以通过将表与其自身连接起来来做到这一点。我为您做了一个示例:(如果您想尝试我的代码并在您的表中重用它，您可以使用此测试表)。

CREATE TABLE test
    (`id` int, `productName` varchar(7), `description` varchar(55))
;

INSERT INTO test
    (`id`, `productName`, `description`)
VALUES
    (1, 'OpenIDM', 'Platform for building enterprise provisioning solutions'),
    (2, 'OpenAM', 'Full-featured access management'),
    (3, 'OpenDJ', 'Robust LDAP server for Java')
;

以及查询:

    SELECT
     CASE
     WHEN query = '1' THEN productName
     ELSE "ANY WORD"
     END AS name
     FROM (
    SELECT 1 AS query, t1.* FROM test AS  t1
    UNION
    SELECT 2 AS query, t2.* FROM test AS t2
)AS t3 ORDER BY id, query;

如果不清楚，请询问您需要的任何内容。

不确定如何在 sql fiddle 中保存查询，但您可以将其粘贴到此处:http://sqlfiddle.com/#!9/8f530/1