## æ¥è¯¢è¡¨è¾¾å¼
æ¥è¯¢è¡¨è¾¾å¼æ¯æ大é¨åçSQLæ¥è¯¢è¯æ³ï¼ä¹æ¯`ThinkPHP`æ¥è¯¢è¯è¨çç²¾é«ï¼æ¥è¯¢è¡¨è¾¾å¼ç使ç¨æ ¼å¼ï¼
~~~
where('å段å','æ¥è¯¢è¡¨è¾¾å¼','æ¥è¯¢æ¡ä»¶');
~~~
é¤äº`where`æ¹æ³å¤ï¼è¿å¯ä»¥æ¯æ`whereOr`ï¼ç¨æ³æ¯ä¸æ ·çã为äºæ´å æ¹ä¾¿æ¥è¯¢ï¼å¤§å¤æ°çæ¥è¯¢è¡¨è¾¾å¼é½æä¾äºå¿«æ·æ¥è¯¢æ¹æ³ã
表达å¼ä¸å大å°åï¼æ¯æçæ¥è¯¢è¡¨è¾¾å¼æä¸é¢å ç§ï¼
| è¡¨è¾¾å¼ | å«ä¹ | å¿«æ·æ¥è¯¢æ¹æ³ |
| --- | --- | --- |
| \= | çäº | |
| <> | ä¸çäº | |
| \> | å¤§äº | |
| \>= | 大äºçäº | |
| < | å°äº | |
| <= | å°äºçäº | |
| \[NOT\] LIKE | 模ç³æ¥è¯¢ | `whereLike/whereNotLike` |
| \[NOT\] BETWEEN | ï¼ä¸å¨ï¼åºé´æ¥è¯¢ | `whereBetween/whereNotBetween` |
| \[NOT\] IN | ï¼ä¸å¨ï¼IN æ¥è¯¢ | `whereIn/whereNotIn` |
| \[NOT\] NULL | æ¥è¯¢å段æ¯å¦ï¼ä¸ï¼æ¯NULL | `whereNull/whereNotNull` |
| \[NOT\] EXISTS | EXISTSæ¥è¯¢ | `whereExists/whereNotExists` |
| \[NOT\] REGEXP | æ£åï¼ä¸ï¼å¹é
æ¥è¯¢ï¼ä»
æ¯æMysqlï¼ | |
| \[NOT\] BETWEEN TIME | æ¶é´åºé´æ¯è¾ | whereBetweenTime |
| \> TIME | 大äºæ个æ¶é´ | `whereTime` |
| < TIME | å°äºæ个æ¶é´ | `whereTime` |
| \>= TIME | 大äºçäºæ个æ¶é´ | `whereTime` |
| <= TIME | å°äºçäºæ个æ¶é´ | `whereTime` |
| EXP | 表达å¼æ¥è¯¢ï¼æ¯æSQLè¯æ³ | `whereExp` |
| find in set |FIND\_IN\_SETæ¥è¯¢| `whereFindInSet` |
表达å¼æ¥è¯¢çç¨æ³ç¤ºä¾å¦ä¸ï¼
## çäºï¼=ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id','=',100)->select();
~~~
åä¸é¢çæ¥è¯¢çæ
~~~
Db::name('user')->where('id',100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` = 100
~~~
## ä¸çäºï¼<>ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id','<>',100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` <> 100
~~~
## 大äºï¼>ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id','>',100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` > 100
~~~
## 大äºçäºï¼>=ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id','>=',100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` >= 100
~~~
## å°äºï¼<ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id', '<', 100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` < 100
~~~
## å°äºçäºï¼<=ï¼
ä¾å¦ï¼
~~~
Db::name('user')->where('id', '<=', 100)->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` <= 100
~~~
## \[NOT\] LIKEï¼ åsqlçLIKE
ä¾å¦ï¼
~~~
Db::name('user')->where('name', 'like', 'thinkphp%')->select();
~~~
æç»çæçSQLè¯å¥æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `name` LIKE 'thinkphp%'
~~~
`like`æ¥è¯¢æ¯æ使ç¨æ°ç»
~~~
Db::name('user')->where('name', 'like', ['%think','php%'],'OR')->select();
~~~
å®é
çæçSQLè¯å¥ä¸ºï¼
~~~
SELECT * FROM `think_user` WHERE (`name` LIKE '%think' OR `name` LIKE 'php%')
~~~
为äºæ´å æ¹ä¾¿ï¼åºè¯¥ç´æ¥ä½¿ç¨`whereLike`æ¹æ³
~~~
Db::name('user')->whereLike('name','thinkphp%')->select();
Db::name('user')->whereNotLike('name','thinkphp%')->select();
~~~
## \[NOT\] BETWEEN ï¼åsqlç\[not\] between
æ¥è¯¢æ¡ä»¶æ¯æå符串æè
æ°ç»ï¼ä¾å¦ï¼
~~~
Db::name('user')->where('id','between','1,8')->select();
~~~
åä¸é¢ççæï¼
~~~
Db::name('user')->where('id','between',[1,8])->select();
~~~
æç»çæçSQLè¯å¥é½æ¯ï¼
~~~
SELECT * FROM `think_user` WHERE `id` BETWEEN 1 AND 8
~~~
æè
使ç¨å¿«æ·æ¥è¯¢æ¹æ³ï¼
~~~
Db::name('user')->whereBetween('id','1,8')->select();
Db::name('user')->whereNotBetween('id','1,8')->select();
~~~
## \[NOT\] INï¼ åsqlç\[not\] in
æ¥è¯¢æ¡ä»¶æ¯æå符串æè
æ°ç»ï¼ä¾å¦ï¼
~~~
Db::name('user')->where('id','in','1,5,8')->select();
~~~
åä¸é¢ççæï¼
~~~
Db::name('user')->where('id','in',[1,5,8])->select();
~~~
æç»çSQLè¯å¥ä¸ºï¼
~~~
SELECT * FROM `think_user` WHERE `id` IN (1,5,8)
~~~
æè
使ç¨å¿«æ·æ¥è¯¢æ¹æ³ï¼
~~~
Db::name('user')->whereIn('id','1,5,8')->select();
Db::name('user')->whereNotIn('id','1,5,8')->select();
~~~
>[info] `[NOT] IN`æ¥è¯¢æ¯æ使ç¨éå
æ¹å¼
## \[NOT\] NULL ï¼
æ¥è¯¢å段æ¯å¦ï¼ä¸ï¼æ¯`Null`ï¼ä¾å¦ï¼
~~~
Db::name('user')->where('name', null)
->where('email','null')
->where('name','not null')
->select();
~~~
å®é
çæçSQLè¯å¥ä¸ºï¼
~~~
SELECT * FROM `think_user` WHERE `name` IS NULL AND `email` IS NULL AND `name` IS NOT NULL
~~~
å¦æä½ éè¦æ¥è¯¢ä¸ä¸ªå段çå¼ä¸ºå符串`null`æè
`not null`ï¼åºè¯¥ä½¿ç¨ï¼
~~~
Db::name('user')->where('title','=', 'null')
->where('name','=', 'not null')
->select();
~~~
æ¨èçæ¹å¼æ¯ä½¿ç¨`whereNull`å`whereNotNull`æ¹æ³æ¥è¯¢ã
~~~
Db::name('user')->whereNull('name')
->whereNull('email')
->whereNotNull('name')
->select();
~~~
## EXPï¼è¡¨è¾¾å¼
æ¯ææ´å¤æçæ¥è¯¢æ
åµ ä¾å¦ï¼
~~~
Db::name('user')->where('id','in','1,3,8')->select();
~~~
å¯ä»¥æ¹æï¼
~~~
Db::name('user')->where('id','exp',' IN (1,3,8) ')->select();
~~~
`exp`æ¥è¯¢çæ¡ä»¶ä¸ä¼è¢«å½æå符串ï¼æ以åé¢çæ¥è¯¢æ¡ä»¶å¯ä»¥ä½¿ç¨ä»»ä½SQLæ¯æçè¯æ³ï¼å
æ¬ä½¿ç¨å½æ°åå段å称ã
æ¨è使ç¨`whereExp`æ¹æ³æ¥è¯¢
~~~
Db::name('user')->whereExp('id', 'IN (1,3,8) ')->select();
~~~
- åºè¨
- åºç¡
- å®è£
- å¼åè§è
- ç®å½ç»æ
- é ç½®
- æ¶æ
- 请æ±æµç¨
- æ¶ææ»è§
- å ¥å£æ件
- å¤åºç¨æ¨¡å¼
- URL访é®
- 容å¨åä¾èµæ³¨å ¥
- æå¡
- é¨é¢
- ä¸é´ä»¶
- äºä»¶
- è·¯ç±
- è·¯ç±å®ä¹
- åéè§å
- è·¯ç±å°å
- è·¯ç±åæ°
- è·¯ç±ä¸é´ä»¶
- è·¯ç±åç»
- èµæºè·¯ç±
- 注解路ç±
- è·¯ç±ç»å®
- ååè·¯ç±
- MISSè·¯ç±
- è·¨å请æ±
- URLçæ
- æ§å¶å¨
- æ§å¶å¨å®ä¹
- åºç¡æ§å¶å¨
- 空æ§å¶å¨
- èµæºæ§å¶å¨
- æ§å¶å¨ä¸é´ä»¶
- 请æ±
- 请æ±å¯¹è±¡
- 请æ±ä¿¡æ¯
- è¾å ¥åé
- 请æ±ç±»å
- HTTP头信æ¯
- 伪éæ
- åæ°ç»å®
- 请æ±ç¼å
- ååº
- ååºè¾åº
- ååºåæ°
- éå®å
- æ件ä¸è½½
- æ°æ®åº
- è¿æ¥æ°æ®åº
- åå¸å¼æ°æ®åº
- æ¥è¯¢æé å¨
- æ¥è¯¢æ°æ®
- æ·»å æ°æ®
- æ´æ°æ°æ®
- å é¤æ°æ®
- æ¥è¯¢è¡¨è¾¾å¼
- é¾å¼æä½
- where
- table
- alias
- field
- strict
- limit
- page
- order
- group
- having
- join
- union
- distinct
- lock
- cache
- comment
- fetchSql
- force
- partition
- failException
- sequence
- replace
- extra
- duplicate
- procedure
- èåæ¥è¯¢
- å页æ¥è¯¢
- æ¶é´æ¥è¯¢
- é«çº§æ¥è¯¢
- è§å¾æ¥è¯¢
- JSONå段
- åæ¥è¯¢
- åçæ¥è¯¢
- æ¥è¯¢äºä»¶
- è·åå¨
- äºå¡æä½
- åå¨è¿ç¨
- æ°æ®é
- æ°æ®åºé©±å¨
- 模å
- å®ä¹
- 模åå段
- æ°å¢
- æ´æ°
- å é¤
- æ¥è¯¢
- æ¥è¯¢èå´
- JSONå段
- è·åå¨
- ä¿®æ¹å¨
- æç´¢å¨
- æ°æ®é
- èªå¨æ¶é´æ³
- åªè¯»å段
- 软å é¤
- ç±»å转æ¢
- 模åè¾åº
- 模åäºä»¶
- 模åå ³è
- ä¸å¯¹ä¸å ³è
- ä¸å¯¹å¤å ³è
- è¿ç¨ä¸å¯¹å¤
- è¿ç¨ä¸å¯¹ä¸
- å¤å¯¹å¤å ³è
- å¤æå ³è
- å ³èé¢è½½å ¥
- å ³èç»è®¡
- å ³èè¾åº
- è§å¾
- 模æ¿åé
- è§å¾è¿æ»¤
- 模æ¿æ¸²æ
- 模æ¿å¼æ
- è§å¾é©±å¨
- é误åæ¥å¿
- å¼å¸¸å¤ç
- æ¥å¿å¤ç
- è°è¯
- è°è¯æ¨¡å¼
- Traceè°è¯
- SQLè°è¯
- åéè°è¯
- è¿ç¨è°è¯
- éªè¯
- éªè¯å¨
- éªè¯è§å
- é误信æ¯
- éªè¯åºæ¯
- è·¯ç±éªè¯
- å ç½®è§å
- 表å令ç
- 注解éªè¯
- æ项
- ç¼å
- Session
- Cookie
- å¤è¯è¨
- ä¸ä¼
- å½ä»¤è¡
- å¯å¨å ç½®æå¡å¨
- æ¥ççæ¬
- èªå¨çæåºç¨ç®å½
- å建类åºæ件
- æ¸ é¤ç¼åæ件
- çææ°æ®è¡¨å段ç¼å
- çæè·¯ç±æ å°ç¼å
- è¾åºè·¯ç±å®ä¹
- èªå®ä¹æ令
- æ©å±åº
- æ°æ®åºè¿ç§»å·¥å ·
- Workerman
- thinkå©æå·¥å ·åº
- éªè¯ç
- Swoole
- éå½
- å©æå½æ°
- å级æ导
- æ´æ°æ¥å¿