<p>Grab all of the entry IDs you want from the <code>craft_entries</code> table, then find the rows matching those IDs in the <code>craft_elements</code> table and set their <code>enabled</code> column to <code>0</code> to disable them en masse.</p>

CC BY-SA 3.0
2014-09-12T02:42:51.363Z
2014-09-12T02:42:51.363Z
Brad Bell
<p>I've looked through all the tables, and I can not find a column for status. I'd like to close all entries in channelId X. Is there a way to bulk edit entries via DB?</p>

<entries><channels><status>
How can I change status of all the entries in a channel to closed?
# How can I change status of all the entries in a channel to closed?

(Asked by: username_0 on 2014-09-11)

I've looked through all the tables, and I can not find a column for status. I'd like to close all entries in channelId X. Is there a way to bulk edit entries via DB?

**Tags:** entries, channels, status


---

## 1 answers

### Answer by username_1 on 2014-09-12. Score: 2 | Accepted answer

Grab all of the entry IDs you want from the `craft_entries` table, then find the rows matching those IDs in the `craft_elements` table and set their `enabled` column to `0` to disable them en masse.


---

