mysql语句求助

[hai159753]

select `X`,`Y` FROM `test`
我想排除X=12，Y=12。和X=15，Y=15得到的数据。这条SQL昨查？

[rucypli]

上面错了 select X,Y from test5 where concat(X,':',Y) not in ('12:12','15:15') ;

[rucypli]

select `X`,`Y` FROM `test` where (X!=12 and Y!=12) or (X!=15 and Y!=15)

[hai159753]

引用 1 楼 rucypli 的回复:

select `X`,`Y` FROM `test` where (X!=12 and Y!=12) or (X!=15 and Y!=15)

给分给得太快。。放到真实发现 SELECT * FROM `test` WHERE PlayerId = '1' AND ( ( `Row` != '26' AND `Col` != '7' ) OR ( `Row` != '26' AND `Col` != '8' ) OR ( `Row` != '25' AND `Col` != '7' ) ) 多于三个就会有问题。。。。。。。。。。

[hai159753]

引用 1 楼 rucypli 的回复:

select `X`,`Y` FROM `test` where (X!=12 and Y!=12) or (X!=15 and Y!=15)

是多于2个就出问题了。