For Pathfinder, d20pfsrd.com offers an advanced spell search for a plethora of rulebook sources. Sometimes, however, it's very difficult to find spells that match my search criteria closely enough. Either it still yields too many results or doesn't produce any at all.
For example, one of my character design goals is to be in dim light conditions as much as possible. This can be achieved with darkness or darklight lantern, but possibly also by a lot of other spells or magic items.
While it can be fun to stumble upon useful spells and items, it would be very handy if there was a good way of pinpointing them more efficiently. I'd like to know what are good ways to find spells and magic items that match my character design goals.
I wouldn't mind answers or comments that address my specific example above (because that is a real problem I'm having), but I think everyone could benefit from answers that address the general problem of finding spells and items to match anyone's design goals.