-
SQL Code
Hey everyone,
Heres an example of what I want:
I'm looking for an SQL code to run in my database to merge all items in the Rares catalogue with the VIP catalogue.
So I want to change the catalogue page of all items in the rare catalogue page to the VIP catalogue. Otherwise it would take me ages to change all items one by one.
Sorry for my bad English, I hope everyone understands this!
-
Re: SQL Code
Whats the page id of both the catalogues?
-
Re: SQL Code
UPDATE `catalog_items` SET `page_id` = 'PAGEID Rares page' WHERE `page_id` = 'PAGEID VIP Page';
Something like this?