mysql - 如何使用循环系统生成随机匹配？

Question

给定这些表格 Players

| id |   name   |
+----+----------+
| 1  |  tawing  |
| 2  |  master  |
| 3  |  pepe    |
| 4  |  bethel  |
| 5  |  richard |

匹配:牵引 vs 主人大师 vs 佩佩主人对伯特利master vs richard....

这是我到目前为止尝试过的方法

select t1.id
       , t1.name 
from Players t1 
cross apply Players t2

Answer 1

这是你要找的吗:

select concat(t1.name ,' vs ',  t2.name) "Match-up"
from players t1 
cross join players t2
where t1.name <> t2.name;

DEMO