为了有效利用索引,您可以重写IN谓词
(x0, y0, x1, y1) IN ((4, 3, 5, 6),(9, 3, 2, 1))
像这样:
( ( x0 = 4 AND y0 = 3 AND x1 = 5 AND y1 = 6 )
OR ( x0 = 9 AND y0 = 3 AND x1 = 2 AND y1 = 1 )
)
MySQL IN子句中的多列
为了有效利用索引,您可以重写IN谓词
(x0, y0, x1, y1) IN ((4, 3, 5, 6),(9, 3, 2, 1))
像这样:
( ( x0 = 4 AND y0 = 3 AND x1 = 5 AND y1 = 6 )
OR ( x0 = 9 AND y0 = 3 AND x1 = 2 AND y1 = 1 )
)