### 傳參條件： #### 一個參數 > 參數為字符時，直接拼入 SQL > 參數為數組時，數組的每一項分別作為條件執行where 查詢（用法見本章節最后那個示例） #### 二個參數 > 二個參數分別表示：字段名， 值 > 如: where('sex', '女') > 等效SQL：WHERE sex = '女' #### 三個參數 > 三個參數分別表示：字段名， 操作符，值 > 如：where('age', '>=', 18); > 等效SQL： WHERE age >= 16 > 如：where('age', 'IN', [18,19,20]); > 等效SQL： WHERE age IN (18,19,20) > > 操作符可選值：=/<>/!=/>/</>=/<=/between/not between/in/not in/like/not like ### 用法預覽 ~~~ $table->where('username','Tom'); $table->where('username','like','Tom'); $table->where('age','=',18); $table->where('age','>',18); $table->where('age','between', [18, 30]); $table->where('user_id','in', [1, 2, 3, 4]); $table->where('username LIKE \'Tom\''); $table->where('username LIKE ?', ['Tom']); $table->where('(')->where('username','like','Tom')->where('OR')->where('age','>',18)->where(')'); $table->where([ ['username','Tom'], 'OR', ['age','>',18], ]); // 最終SQL: WHERE (username='Tom' OR age>18) ~~~ ### 代碼示例： #### 按某個字段的指定值查詢 ~~~ $tableUser = Be::getTable('system_user'); $tableUser->where('sex', '女'); $users = $tableUser->getObjects(); ~~~ 等效SQL: ~~~ SELECT * FROM user WHERE sex = '女' ~~~ #### 按某個字段的指定范圍查詢 ~~~ $tableUser = Be::getTable('system_user'); $tableUser->where('age', '>=', 18); $users = $tableUser->getObjects(); ~~~ 等效SQL: ~~~ SELECT * FROM user WHERE age >= 18 ~~~ #### 多個條件 ~~~ $tableUser = Be::getTable('system_user'); $tableUser->where('sex', '女'); $tableUser->where('age', '>=', 18); $users = $tableUser->getObjects(); ~~~ 等效SQL: ~~~ SELECT * FROM user WHERE sex = '女' AND age >= 18 ~~~ #### 連貫操作 ~~~ $users = Be::getTable('system_user') ->where('sex', '女') ->where('age', '>=', 18) ->getObjects(); ~~~ #### 字段控制 ~~~ $users = Be::getTable('system_user') ->where('sex', '女') ->getObjects('id, name, sex'); ~~~ 等效SQL: ~~~ SELECT id, name, sex FROM user WHERE sex = '女' ~~~ #### 復雜條件： ~~~ $users = Be::getTable('system_user') ->where('(') ->where('sex', '女') ->where('AND') ->where('age', '>=', 18) ->where(')') ->where('OR') ->where('sex', '男') ->getObjects(); ~~~ 等效SQL: ~~~ SELECT * FROM user WHERE (sex = '女' AND age >= 18) OR sex = '男' ~~~ #### 數組形式的多維 where 條件 ~~~ $where = [ '(', ['sex', '女'], 'AND', ['age', '>=', 18], ')', 'OR', ['sex', '男'] ]; $users = Be::getTable('system_user') ->where($where) ->getObjects(); ~~~ 等效于上例中的復雜條件查詢