UPDATE items SET SOURCE='other', sourcename='Unknown (Let us know!)' WHERE itemid IN (SELECT * FROM items WHERE (name REGEXP 'of the Fortress$' OR name REGEXP 'of the Anointed$' OR name REGEXP 'of the Devout$' OR name REGEXP 'of the Sovereign$' OR name REGEXP 'of the Defender$' OR name REGEXP 'of the Stalwart$' OR name REGEXP 'of Valor$' OR name REGEXP 'of the Mythical$') AND SOURCE IS NULL)
1241: Operand should contain 1 COLUMN(s)