Question

sql语句多栏目调用

sql="SELECT id,left(title,10) as title FROM web.code_soft where id=5 ORDER BY id DESC"这段代码中ID=5是调用栏目5的信息。我想要调用多栏目5 栏目6栏目7应该怎么写。谢谢

Answer 1

where id=5 改成where id in(5,6,7)