select `X`,`Y` FROM `test`
我想排除 X=3,Y=4 和 X=5,Y=6 和 X=7 ,Y=8 得到的数据。这条SQL昨查?
SELECT * FROM `test` WHERE PlayerId = '1' AND ( ( `Row` != '3' AND `Col` != '4' ) OR ( `Row` != '5' AND `Col` != '6' ) )这样可以查到两条的。多于就无法查了。
我想排除 X=3,Y=4 和 X=5,Y=6 和 X=7 ,Y=8 得到的数据。这条SQL昨查?
SELECT * FROM `test` WHERE PlayerId = '1' AND ( ( `Row` != '3' AND `Col` != '4' ) OR ( `Row` != '5' AND `Col` != '6' ) )这样可以查到两条的。多于就无法查了。
FROM `test`
WHERE PlayerId = '1' AND concat(ROW,':',Col) not in ('3:4','5:6','7:8');
SELECT * FROM `test` WHERE PlayerId = '1' AND NOT((ROW % 2)=1 AND COL=ROW+1)