# 부울 검색의 대안

**URL:** https://meta.discourse.org/t/alternatives-to-boolean-search/143357
**Category:** Support
**Created:** [3월 4, 2020, 10:54오후 UTC](https://meta.discourse.org/t/alternatives-to-boolean-search/143357 "2020-03-04T22:54:07Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![yanokwa](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/yanokwa/32/105083_2.png) [@yanokwa](https://meta.discourse.org/u/yanokwa)
#### Post date: [3월 4, 2020, 10:54오후 UTC](https://meta.discourse.org/t/alternatives-to-boolean-search/143357/1 "2020-03-04T22:54:07Z")

</div>

keyword1 또는 keyword2 또는 keyword3가 포함된 토픽 목록을 일회성으로 가져오고 싶습니다. 유사한 쿼리를 시도해 봤는데, Discourse의 검색 UI는 아직 [부울 연산자를 지원하지 않는 것 같습니다](https://meta.discourse.org/t/boolean-operators-in-search/30646). 이 토픽 목록을 가져올 수 있는 대안(예: 플러그인, Rails 태스크 등)이 있을까요?

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [3월 5, 2020, 12:19오전 UTC](https://meta.discourse.org/t/alternatives-to-boolean-search/143357/3 "2020-03-05T00:19:05Z")

</div>

데이터 탐색기 쿼리가 바로 떠오릅니다.

---

<div class="post-metadata">

### Author: ![yanokwa](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/yanokwa/32/105083_2.png) [@yanokwa](https://meta.discourse.org/u/yanokwa)
#### Post date: [3월 6, 2020, 6:36오후 UTC](https://meta.discourse.org/t/alternatives-to-boolean-search/143357/4 "2020-03-06T18:36:15Z")

</div>

감사합니다! [Data Explorer](https://meta.discourse.org/t/32566?silent=true)에서 이와 유사한 코드를 사용했고 잘 작동했습니다.

```sql
SELECT 
  topic_id 
FROM 
  posts 
WHERE 
  raw LIKE '%keyword1%' 
  OR raw LIKE '%keyword2%'

```

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [4월 5, 2020, 6:36오후 UTC](https://meta.discourse.org/t/alternatives-to-boolean-search/143357/5 "2020-04-05T18:36:16Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.