# What is the bug reporter badge?

**URL:** <https://meta.discourse.org/t/what-is-the-bug-reporter-badge/17987>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [2014 年7 月 24 日 08:58 UTC](https://meta.discourse.org/t/what-is-the-bug-reporter-badge/17987 "2014-07-24T08:58:01Z")\
**Posts on this page:** 1\
**Showing post:** 19

<div class="post-metadata">

作者： ![simonk](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simonk/32/247950_2.png) [@simonk](https://meta.discourse.org/u/simonk)\
发布日期： [2015 年10 月 30 日 11:54 UTC](https://meta.discourse.org/t/what-is-the-bug-reporter-badge/17987/19 "2015-10-30T11:54:32Z")

</div>

> [@john\_mardlin](#):
>
> SELECT id FROM categories WHERE name ilike ‘%oauth%’
> 
> but couldn’t extend it with alternation ie. ‘%oauth%|%developers%’

You want something like:

```
SELECT id FROM categories
WHERE name ilike '%oauth%'
OR name ilike '%developers%'

```

If you’ve got the exact category names, you could also use:

```
SELECT id FROM categories
WHERE name IN ('OAuth', 'Developers')

```

…but note that the names must match exactly (including case).

---

_[View the full topic](https://meta.discourse.org/t/what-is-the-bug-reporter-badge/17987)._