searching database

[slick101]

Hey guys im in process creating a search engine for my site.

The thing is i understand on how create a simple search engine doing like

Select * from people WHERE name LIKE '%John%'

but now lets say I have like 15 different type of tables that consist of info like images, blogs, usernames etc and multiple fields.

How do I go by searching all the tables looking for specific words that the user has typed?

Is a crawler good for this situation? I use a template system called smarty and I have template file that could be like 100 different pages. So would that even work?

[djjjozsi]

build an array, where you write down all the tables with label names.
Store the field names in this array to specify the search type for the fields, fulltext, range, ect.

finally you will build the queries depending the "content type"

The categories will be your table's label names.

The results could store which content you're talking about, if you specify a link template, you can build details page to that related entry.

The main search should use a dropdown or a multile list element to select which content type you want to select.

I'm using database to store these parameters.