Thank Adam, but what the BODY attribute does is lumps all
those fields into one field, "summary". This doesn't fit with what
I'm trying to do. Here's an example.
table structure (scaled down of course)
ID, fname, lastname, email, manager_fname, manager_lname,
dept.
I would like to index all of those items, so that when
someone types in the search box (google-style), "John", I get all
the rows that contain "*john*" within the index.
a sample return would be:
ID fname lname email manager_fname manager_lname dept
3 john jones jjones fred hicks marketing
4 jack smith jsmith john jones sales
any idea?