[Kingly_Krab]

Lore isn't marked by 'Lore', it's marked by 'loregroup'.

/*Takes away Lore from all items*/
UPDATE items SET `loregroup` = 0 WHERE `loregroup` = -1;

Here's a link to the Wiki Page for items: Items Wiki Page
Should help you out. :P