Thanks to ur post I was able to make my adjustments I was looking for to my database.
Code:
UPDATE items SET gmflag=1 WHERE lore LIKE '*guide item%'
UPDATE items SET gmflag=1 WHERE lore LIKE 'guide item%'
Matches 25 items in the PEG_Kunark Database.
Another useful one is
Code:
UPDATE items SET gmflag=1 WHERE damage >=100;