MySQL query response makes no sense.

[Luicy]

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;

 

[The General]

offer_active = '1' ? Use single quotes around the 1

 

[Luicy]

offer_active = '1' ? Use single quotes around the 1

Ah yes, appreciate the help so quickly.