Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Opening a large number of closed entries with mysql query?

June 29, 2012 9:07am

Subscribe [1]

#1 / Jun 29, 2012 9:07am
Linda A
666 posts
Hi,

I’ve ended up in a situation where I need to open a large number of closed weblog entries. Doing it manually would take ... quite a while, so I have been poking around trying to find a way to do it with a mysql query.

Would this query be right?
```
update exp_weblog_titles
set status= 'open'
where weblog_id = '39';
```
All the entries that need to be opened are in the weblog with id 39.

I am using EE 1.7.3