+ -
当前位置:首页 → 问答吧 → 请问这样的mysql语句可以精简吗?

请问这样的mysql语句可以精简吗?

时间:2011-08-28

来源:互联网

SQL code

select * from article,user where article.userid = '1' and article.userid = user.userid or article.userid = '2' and article.userid = user.userid or article.userid = '3' and article.userid = user.userid or article.userid = '4' and article.userid = user.userid  or article.userid = '5' and article.userid = user.userid ORDER BY articleid DESC




也就是说,userid 会有很多,请问可以精简吗?

作者: BraveRu   发布时间: 2011-08-28

SQL code
select * from article,user
where article.userid = user.userid 
and article.userid in ('1', '2', '3', '4', '5')
ORDER BY articleid DESC

作者: ACMAIN_CHM   发布时间: 2011-08-28

lz的or and 在一起是什么逻辑


select * from article,user 
where article.userid = user.userid or article.userid in ('1','2','3','4','5') 
ORDER BY articleid DESC
这样?

作者: rucypli   发布时间: 2011-08-28