Clive Portman: code

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'