Thoughts on best way to create a search engine on my site to
pull data from my DB

Hello all,

I have a page that will be a Knowledge Base page. It will pull the data from a
Access DB (Will be changed to SQL at sometime in future).

The Table currently has the fields of Article ID, Article Name, Article,
Keywords, Attachment, Created By, Created Date, Edited By, Edited Date.

I would like your thoughts on the best way to create a search engine for the
user and any tips for data storage.

Currently I have a textbox and button. I also thought about placing option
buttons to choose to search by article ID, Keywords, or Article. Thinking that
this would speed up the searches.

 

Thanks

Ty