Advanced Search Plugin

Hi all,
I’m building some custom functionality for a client. They need a custom search with a couple of options.

The site is setup like this:
Note: widget means imaginary product here, not a WP widget =).

Widget Category
-Type of Widget (Subcategory to Widget Category – Several of these)
–Name of specific widget (This will be the name of the post)
—Info about specific widget (This will be the post content)

I need to find a plugin or develop a custom search that would allow the user to select from a drop down box that looks like this:

Search By: -Type of Widget
-Name of Widget
-Widget Info

then there will be a text box where a keyword can be entered, and it will search either the subcategories, post titles, or post content for this keyword, depending on the select box.

I guess I could create some custom functionality to run different database queries using LIKE on the appropriate fields. Can anyone think of better way of doing this? Or a plugin/mod that already does something like this that I could just modify?