# SQL Query to extract all posts with unchecked checkboxes

**URL:** https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [January 15, 2024, 12:37am UTC](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634 "2024-01-15T00:37:25Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [January 15, 2024, 7:22am UTC](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634/4 "2024-01-15T07:22:04Z")

</div>

That’s right. 👍

> [@Discourse Checklist](https://meta.discourse.org/t/discourse-checklist/36362/1):
>
> Once enabled, you can add checklists to your posts by typing them in like this:
> 
> - `[]` or `[]` for an unchecked box
> - `[x]` for checked box (no fill)
> - `[X]` for a checked box (with fill) - Permanent option, which can no longer be toggled

Though if you use `cooked` instead of `raw` you’d see that they get converted into the icon. I’m not sure if that would be easier to search on though?

---

_[View the full topic](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634)._