I'm in the process of creating my own directory, and one of the things I would like to do is to create a search script when you type in a search term and queries the DB.
The results will show the title, description, and the category which the search term belongs to.
Now I'm not quite sure whether I need to do some alterations to the DB, so that it allows the script to search the text quickly, some indexing change etc.
Are there any tutorials or ready made scripts out there in which I can alter to my needs?
This is something I've never grasped as a developer, and really interested how this is achieved.
Any suggestions is appreciated.