1. cliveportman
  2. /code
  3. /expressionengine-close-all-entries-in-a-channel

Close all entries in an ExpressionEngine channel

UPDATE exp_channel_titles t 
SET t.status = 'closed' 
WHERE t.status = 'open'
AND t.channel_id = '3'