You are supposed to add a FULLTEXT index to multiple columns of the database. If the instructions in the problem specification are too vague, try searching Google for "MySQL FULLTEXT Search".
These web tutorials should help you to get started.
By the way, my personal advice is not to get bogged down too much in this section. Once you have defined a
FULLTEXT index on the tables you want to search, just pass the value of
$_GET['geo'] to your query and focus on getting to the point where you have pins in your map.
Once you have a minimally-functional app, you can come back and get lost in the intricacies of MySQL Natural Language Searches and Boolean Full-text Searches until your search is working the way you want it to.
By the way, if this answers your question, be sure to accept it by clicking the green check mark. Otherwise, it will haunt the forums forever as a zombie unanswered question!
How do you define a
FULLTEXT index? Well, there is a way to do it with phpMyAdmin, which you can discover by trial and error (or via Google). But the tutorials I linked to above will explain how to do it using
mysql50 shell interface, like a real Database Administrator would.
To get started, type the following commands in a new
ide50 Terminal tab:
Then you could use either the
ALTER TABLE table_name ADD FULLTEXT (column_one, column_two) syntax or the
CREATE FULLTEXT INDEX index_name ON table_name(column_one,column_two) syntax to add a
FULLTEXT index for the specified tables.