mysql where in带2个参数的查询方式

数据结构如下

下面两句的查询结果都是一样的

SELECT
	id
FROM
	t3
WHERE
	(n1, n2) IN (
		SELECT
			n1,
			n2
		FROM
			t3
		WHERE
			id <= 2
	)
------------------------------------------------------
SELECT
	id
FROM
	t3
WHERE
	(n1, n2) IN ((1, 'a'),(2, 'b'))

结果

id

1

2