Question

sql的 select语句则么写就是select * from name where a 或者b怎么写就是满足a或者b即可

Answer 1

select * from tab_name where name like '%a%' or name like '%b%'
海枫科技

Answer 2

select * from name where a or b

追问

那我要选择a或者b满足即可但是c必须满足呢？

追答

select * from name where c and (a or b )一般不会出现这样的情况，因为语句可以灵活变化

Answer 3

select * from tablename where a or b;

追问

那我要选择a或者b满足即可但是c必须满足呢？

追答

select * from tablename where (a or b) and c;

Answer 4

select * from name where a=' ' or b=' '

追问

那我要选择a或者b满足即可但是c必须满足呢？