Rule based categorization of string

@wantti if it is an exact match can you just use a left join?