---
# System prepended metadata

title: AND

---

# AND

## 搜尋培根、法釐->AND

#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+培根 +法釐' IN BOOLEAN MODE);
![](https://i.imgur.com/yCW5sdA.png)

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '培根 法釐'
![](https://i.imgur.com/FXhO6fH.png)



## 搜尋愧的歸、我們必->AND
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+愧的歸 +我們必' IN BOOLEAN MODE);

![](https://i.imgur.com/zN7Qtn4.png)

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '愧的歸 我們必'
![](https://i.imgur.com/nCa3Jim.png)

## 搜尋試的意義、對是史無->AND
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+試的意義 +對是史無' IN BOOLEAN MODE);
![](https://i.imgur.com/6vciMT0.png)

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試的意義 對是史無'
![](https://i.imgur.com/OwYt953.png)


## 搜尋慮周詳測試、問題的關鍵->AND
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+慮周詳測試 +問題的關鍵' IN BOOLEAN MODE);
![](https://i.imgur.com/xQocCGo.png)

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試的意義 對是史無'
![](https://i.imgur.com/w0YdoTU.png)


# OR
## 搜尋試很、是解->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('試很 是解' IN BOOLEAN MODE);
![](https://i.imgur.com/9wJeqAN.png)


#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試很 OR 是解'
![](https://i.imgur.com/iaqG26j.png)


## 搜尋試的美、蓄意背->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('試的美 蓄意背' IN BOOLEAN MODE);
![](https://i.imgur.com/IH9VefR.png)



#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試很 OR 是解'
![](https://i.imgur.com/HlvCgTn.png)


## 搜尋含的深遠、療這個毛->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('含的深遠 療這個毛' IN BOOLEAN MODE);
![](https://i.imgur.com/2IcxkbM.png)

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '含的深遠 OR 療這個毛'
![](https://i.imgur.com/q1QFWgU.png)


## 搜尋方沉醉於愛、往卻不這麼->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('方沉醉於愛 往卻不這麼' IN BOOLEAN MODE);
![](https://i.imgur.com/KGQRHvV.png)



#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '方沉醉於愛 OR 往卻不這麼'
![](https://i.imgur.com/LJS2xdc.png)














