moving layouts by date to different categories via database/phpmyadmin

glowinggal · June 22nd, 2010, 01:03 PM

We'd like to bulk move layouts by date to different categories to archive them. With THOUSANDS of layouts on our site you can imagine this would take a LONG time to do via the admin control panel.

Is there a query that I could use that would make this task much easier?

Chuck S · June 22nd, 2010, 03:42 PM

well really not something I can say without knowing more about what you mean by dates.

You need to be really specific in mysql with what queries you issue as it can create havoc.

glowinggal · June 22nd, 2010, 10:44 PM

basically we want to move all layouts that are dated say in 2008 to a different category.

Chuck S · June 23rd, 2010, 09:10 AM

well the only way to move things really is through scripting.

You would have to alter the admin bulk move code in some fashion

You cant do it simply by a query alone.