MySQL query response makes no sense.

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.

Quote:

---

UPDATE catalog_items SET offer_active = 1 WHERE page_id = 912378;
SELECT * FROM catalog_items WHERE page_id = 912378;

---

https://image.prntscr.com/image/TpE0...ejdRo_isFQ.png

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

Quote:

---

Originally Posted by The General

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

---

Ah yes, appreciate the help so quickly. (y)