# AND

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

#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+培根 +法釐' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '培根 法釐'

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


#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '愧的歸 我們必'

## 搜尋試的意義、對是史無->AND
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+試的意義 +對是史無' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試的意義 對是史無'

## 搜尋慮周詳測試、問題的關鍵->AND
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('+慮周詳測試 +問題的關鍵' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試的意義 對是史無'

# OR
## 搜尋試很、是解->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('試很 是解' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試很 OR 是解'

## 搜尋試的美、蓄意背->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('試的美 蓄意背' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '試很 OR 是解'

## 搜尋含的深遠、療這個毛->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('含的深遠 療這個毛' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '含的深遠 OR 療這個毛'

## 搜尋方沉醉於愛、往卻不這麼->OR
#### SQL -> SELECT * FROM interface WHERE MATCH (interface_name, interface_description) AGAINST ('方沉醉於愛 往卻不這麼' IN BOOLEAN MODE);

#### postgreSQL -> SELECT * FROM interface WHERE interface_description &@~ '方沉醉於愛 OR 往卻不這麼'