Newbie Spellweaver
- Joined
- Feb 3, 2018
- Messages
- 47
- Reaction score
- 16
So I'm trying to update all rows that's got a page_id column assigned to X, however it makes no change and tells me "0 rows affected". The query is fine, I even tried using a SELECT; query directly after to make sure the page_id is right, but it's working fine.
UPDATE catalog_items SET offer_active = 1 WHERE page_id = 912378;
SELECT * FROM catalog_items WHERE page_id = 912378;