Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2014-09-12T02:42:51.363Z
Answers.LastActivityDate: 2014-09-12T02:42:51.363Z
Answers.UserDisplayName: Brad Bell
Body: <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>
  
Tags: <entries><channels><status>
Title: How can I change status of all the entries in a channel to closed?
ThreadText: # 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.
  
  
  ---
  
  