MySQL数据库3 的 where语句 and 和 or运算符

where语句的运算符

 -- where子句的演示
 -- 根据条件查询
 -- select *from users where id >= 2
 -- select * from users where id = 1
 -- select * from users where usename !='李四'

and 和or运算符：

-- and 和or
-- select * from users where status = 0 and id < 3
select * from users where status = 1 or usename = '李四'