Question

SQL语句，查询同一张表，按不同字段条件查询

select * from zy_zyxmxx where 代码 = 01
select * from zy_zyxmxx where 摘要 = '帐号'
select * from zy_zyxmxx where 拼音码 = 'MM'

三条数据，同时查询，怎么把他们写成一句

Answer 1

方法一：
select * from zy_zyxmxx
where 代码 = 01
or 摘要 = '帐号'
or 拼音码 = 'MM';
方法二：
select * from zy_zyxmxx where 代码 = 01
union
select * from zy_zyxmxx where 摘要 = '帐号'
union
select * from zy_zyxmxx where 拼音码 = 'MM';

Answer 2

select * from zy_zyxmxx where 代码 = 01 and 摘要 = '帐号' and 拼音码 = 'MM'

Answer 3

select * from zy_zyxmxx where 代码 = 01 and 摘要='账号' and 拼音码 = 'MM'

Answer 4

中间用OR,或and

Answer 5

把where条件连一块