i used % in mysql as a wildcard character.
Code:
SELECT ALL FROM npc_types WHERE name LIKE '%goblin%';
selects all things containing goblin in the name.. Dunno if this is at all related.. but .. ya there ya have it )
So if as you said %' was an escape... the above wouldn't in theory work.