Search for a keyword in a database

I simply want to create a search box, enter a keyword in it, search the database for this keyword and load the corresponding subpage. Here is an example of what I am trying to accomplish. Let's say I have travel website with two sub-pages for New York and San Francisco ( newyork.travel.com and sanfrancisco.travel.com ). My database has two raws with the names of my sub-pages. Now when I enter Ney York in the search box I want to search the database and if there is a match then newyork.travel.com should be opened in the browser.

Can you please advise me how to do it? I know how to create a search box and a database, I also know how to create a sql query. What I don't know is how to load a page when a match is found in my database. What function or method should I use.

header() can redirect users to new pages:

Have you thought about what happens if you have more than one entry returned? Do you have a new york city and a new york state visitor's guide?

Thank you. I will definitely try that function. New York city was just an example. Each field in my database will have a unique name. But just out of curiosity if I have two entries returned what would be the best way to handle them?