mysql 彩票统计_MySQL彩票搜索

考虑这个例子 .

假设我们想要匹配这四个球中至少有三个组合的所有结果(2,4,5,10)

我们可以这样做......

SELECT * FROM lottery;

+----+-------+-------+-------+-------+

| id | ball1 | ball2 | ball3 | ball4 |

+----+-------+-------+-------+-------+

| 1 | 2 | 5 | 10 | 4 |

| 2 | 5 | 9 | 4 | 1 |

| 3 | 3 | 6 | 4 | 9 |

| 4 | 4 | 8 | 2 | 3 |

| 5 | 8 | 9 | 4 | 10 |

| 6 | 9 | 2 | 1 | 3 |

| 7 | 2 | 3 | 7 | 8 |

| 8 | 3 | 8 | 2 | 6 |

| 9 | 2 | 5 | 1 | 10 |

| 10 | 3 | 2 | 9 | 5 |

+----+-------+-------+-------+-------+

SELECT id

, GROUP_CONCAT(ball ORDER BY ball) balls

FROM

( SELECT id,ball1 ball FROM lottery

UNION

SELECT id,ball2 ball FROM lottery

UNION

SELECT id,ball3 ball FROM lottery

UNION

SELECT id,