mysql 行行比较

行行比较是 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"))