Hi url PinPointthings,
Welcome to WebmasterWorld!
This is probably not the answer you are looking for, especially in response to your first post, but:
Actually, that's a complicated little project you're asking someone to handle for you and the truth is (form my perspective anyway), unless one of us had all the pertinent information right in front of us, the answer is actually, no...
I actually cannot do what you are asking, because I have no idea how your data is structured, how it should be returned, what information needs to be returned as a result for each search, what fields you might need in the database, how the information is stored currently to tell you how to get it into the database, how future information will be entered into the database, and the list of things I don't know to even make it possible to give you an answer just keep going.
I think the best advice I can give you is:
1.) Find a tutorial and work through it.
2.) Hire someone to do it for you.
If budget is the biggest concern #1 is probably the best option, because once you understand the project, can write some of the project and know how to communicate what people here need to know, we can probably help you work through the places where you get stuck.
If it's going to be a 'site attraction' and speed, efficiency and usefulness are the biggest concerns, it's probably best to hire a professional. My first search engine took me a month to write and get to where I was happy with the efficiency and speed of it. When I say a month I mean a full time job of learning, testing, re-testing, restructuring, expanding my knowledge, testing, more testing, and I had a great deal of frustration along the way to accompany my headaches...
Something you might look for is a tutorial for an AJAX based search, rather than MySql, depending on how much information you need to search. I know I found one when I first started using AJAX that uses an XML file rather than a database and creates a drop down menu of links as the person types... It's absolutely cool if you don't have too much information you need to search, but again we're back to specifics I just plain don't have and everything you are asking for and about is 'application specific' to your needs, wants, goals and website.
Sorry I can't be of much more help... If you decide to write it yourself and have something to show us we can work with, I'm fairly sure one of us will give you a hand working through it, but the short version is most of us (AFAIK) post here to educate rather than work for, and for us to really be able to do that you have to have a working knowledge of what you're doing.