How to perform Multiple Search?

I am working on a mini-project which is a simple movie database....
Uptill now-The user has to input a keyword in the textbox and then select a category in the category drop-down that includes Title, Actors, Director, Rating, Release_year. Then the database searches in the selected category and displays the result.

I want to perform multiple search so that-
If the result is not found in the selected category, then it must switch to another category and search there.

What modifications I should do?

You can create multiple primary keys and set the order/priority to all these primary keys.Then perform search across all the primary keys depending on their order. You can do this by cursor feature of the database so that at the end of each search, the cursor switches to another category search.

Since you have created drop-down menu for the category, you can modify it to multiple select so that the user can select more than one category using the Ctrl button.
Hence, the database seaches more than category to find the result....

To obtain searching for keyword queries, combine tuples from multiple databases

• Identify foreign keys across databases
• Identify matching data instances across databases
• Identify combination of databases as a single database

Apply keyword search techniques