这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录 前一修订版 | |||
zblogphp:development:features:corecomponent:chainquery [2020/12/31 13:07] zx.asd |
zblogphp:development:features:corecomponent:chainquery [2021/01/03 17:35] (当前版本) zx.asd |
||
---|---|---|---|
行 171: | 行 171: | ||
<code sql> | <code sql> | ||
SELECT * FROM zbp_post WHERE ((1 = 1) AND (log_ID IN ( '1' , '2' , '3' , '4' ) ) ) | SELECT * FROM zbp_post WHERE ((1 = 1) AND (log_ID IN ( '1' , '2' , '3' , '4' ) ) ) | ||
+ | </code> | ||
+ | |||
+ | <code php> | ||
+ | $sql = $zbp->db->sql->get()->select("zbp_post") | ||
+ | ->where(array('NOT IN', 'log_ID', '(1, 2, 3)')) | ||
+ | ->sql | ||
+ | </code> | ||
+ | |||
+ | <code sql> | ||
+ | SELECT * FROM zbp_post WHERE (log_ID NOT IN (1, 2, 3)) | ||
</code> | </code> | ||