<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                > 當我們的查詢添加越來越復雜的時候,簡單的結構已經無法滿足我們的需要,這時候我們就會需要一個完整的SQL語句構造,當然,我們考慮到了這些并做了一些調整 ```php //IN查詢 $select = Db('user')->select([ 'field' => ['username', 'email'], //設定查詢的字段 'where' => [ //定義查詢的條件 'id' => array('in','1,6,8,9,10') ], 'limit' => '0, 10', //條數限制 'orderby' => 'username asc', //進行排序 ])->get(); //sql:SELECT `username`,`email` FROM `user` WHERE `id` IN (1,6,8,9,10) ORDER BY username asc LIMIT 0,10 //like查詢 $select = Db('user')->select([ 'field' => ['username', 'email'], //設定查詢的字段 'where' => [ //定義查詢的條件 'username' => array('like','%張') ], 'limit' => '0, 10', //條數限制 'orderby' => 'username asc', //進行排序 ])->get(); //sql:SELECT `username`,`email` FROM `user` WHERE `username` LIKE '%張' ORDER BY username asc LIMIT 0,10 //自定義操作(獲取所有周六注冊的用戶) $select = Db('user')->select([ 'field' => ['username', 'email'], //設定查詢的字段 'where' => [ //定義查詢的條件 '' => array('string',"FROM_UNIXTIME(add_time,'%w')=6") ], 'limit' => '0, 10', //條數限制 'orderby' => 'username asc', //進行排序 ])->get(); //sql:SELECT `username`,`email` FROM `user` WHERE FROM_UNIXTIME(add_time,'%w')=6 ORDER BY username asc LIMIT 0,10 ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看