mysql - 如何查询两列中的多个值

Question

我想检查我的数据库中是否存在两个或多个特定值(例如名字和姓氏)。

Select * from client_info 
where (first_name = "John" and last_name ="Smith")
and   (first_name = "Donald" and last_name ="Trump")
and   (first_name = "Baracj" and last_name ="Obama")

提前致谢

Answer 1

你可以试试这个:

Select * from client_info 
      where (first_name = "John" and last_name ="Smith")
           or (first_name = "Donald" and last_name ="Trump")
           or (first_name = "Baracj" and last_name ="Obama")