如何从MySQL中的变量字符串中选择具有值的行?
如何从MySQL中的变量字符串中选择具有值的行?
提问于 2018-07-26 01:10:50
我希望找到包含以下内容的行：
A, B & C or A & B or C & B or A, C & Specialnum1以下是数据包：
SELECT * FROM game_plays WHERE
`(first_number IN (10, 32, 18, 16, 90, 54) AND
second_number IN (10, 32, 18, 16, 90, 54) AND
third_number IN (10, 32, 18, 16, 90, 54) AND
fourth_number IN (10, 32, 18, 16, 90, 54) AND
fifth_number IN (10, 32, 18, 16, 90, 54) AND
sixth_number IN (10, 32, 18, 16, 90, 54) )OR
((
(first_number IN (10, 32, 18, 16, 90, 54) AND
second_number IN (10, 32, 18, 16, 90, 54) AND
third_number IN (10, 32, 18, 16, 90, 54) AND
fourth_number IN (10, 32, 18, 16, 90, 54) AND
fifth_number IN (10, 32, 18, 16, 90, 54) AND
sixth_number IN (10, 32, 18, 16, 90, 54) )
) AND powerball_number like 23);回答 2
Stack Overflow用户
发布于 2018-07-26 09:21:11
这样试试：
SELECT * FROM game_plays WHERE drawID = 6;
SELECT playID
, GROUP_CONCAT(ball ORDER BY ball) balls
FROM
( SELECT playID,first_number ball FROM game_plays
UNION
SELECT playID,second_number ball FROM game_plays
UNION
SELECT playID,third_number ball FROM game_plays
UNION
SELECT playID,fourth_number ball FROM game_plays
UNION
SELECT playID,fifth_number ball FROM game_plays
UNION
SELECT playID,sixth_number ball FROM game_plays
) x
WHERE ball IN (1,14,12,6,61,54)
GROUP
BY playID
HAVING COUNT(*) >= 2;Stack Overflow用户
发布于 2018-07-26 10:20:06
试试以下代码：
select *
from a
where ( num1 like A and num2 like B and num3 like C)
or (( (num1 like A and num2 like B) or (num3 like C and num2 like B) or (num1 like A and num 3 like C) )
and specialnum1 like Z);SELECT * FROM a WHERE
(num1 IN (A, B, C) AND
num2 IN (A, B, C) AND
num3 IN (A, B, C) ) OR
((
(num1 IN (A, B, C) AND num2 IN (A, B, C) ) OR
(num1 IN (A, B, C) AND num3 IN (A, B, C) ) OR
(num2 IN (A, B, C) AND num3 IN (A, B, C) )
) AND specialnum1 like Z);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/-100005771
复制相关文章
相似问题