行行比较是 SQL-92 中引入的,SQL-92 是 1992 年制定的规范
行行比较示例:
SELECT * FROM `blog_read_number` WHERE (top, blog_name) IN ( (1, "1aaa"), (2, "2aaa"), (2, "2bbb") )
or拼接的写法:
SELECT * FROM `blog_read_number` WHERE (top = 1 and blog_name in ("1aaa")) or (top = 2 and blog_name in ("2aaa", "2bbb"))