C# 查询数据库语句where怎么写
是这样的，我的条件查询 where TYPE == 2 || TYPE == 3
"select * from UDS_MESSAGE where TOUSERNAME like @user order by TIME DESC";
怎么把上面的条件写到这个语句里面？
[解决办法]
where (TYPE == 2 or TYPE == 3) and TOUSERNAME
[解决办法]
或者
select * from UDS_MESSAGE where TYPE in (2,3) and TOUSERNAME like @user order by TIME DESC
[解决办法]
select * from UDS_MESSAGE where TOUSERNAME like @user and ( TYPE = 2 or TYPE = 3)order by TIME DESC
