一次选择两件事


Select for 2 things at once?

我真的不知道如何解释这一点,但我基本上想检查2具体的东西在表的属性。表格如下:


用户:

name => "simples"
age => "Monday"


我怎么检查这两个呢?我觉得应该是这样的:

$query = "SELECT * 
          FROM `data`.`user` 
          WHERE `user`.`name` = 'simples'
           AND `user`.`age`='monday';";

写简单查询:

基本语法:
select * from databasename.tablename where column_name1 = value1 and column_name2 = value2

例如:

SELECT * FROM data.user WHERE name = 'simples' AND age = 'Monday'

查询:

SELECT * FROM user where name='simples' AND age='Monday'