mysql 行行比较

行行比较是 SQL-92 中引入的，SQL-92 是 1992 年制定的规范

 

行行比较示例:

?

1 2 3 4 5 6 7

SELECT * FROM `blog_read_number` WHERE (top, blog_name) IN (                            (1, "1aaa"),                            (2, "2aaa"),                            (2, "2bbb")     )

　　

or拼接的写法:

?

1 2 3 4

SELECT * FROM `blog_read_number` WHERE (top = 1 and blog_name in ("1aaa"))    or (top = 2 and blog_name in ("2aaa", "2bbb"))