How to create user like drop-down filters for a custom module in admin side
Well you have 2 options:


Declare your custom tables with Views. This can be tricky, and take some trial and error, but gives more flexibility going forward.
Declare a custom page in your module (using hook_menu). Then just build a form with the search options you want and build a query. See the Examples modules if you're not sure how to build a page.