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'