Search Functionality

[jtucholski]

When a website adds search functionality, more so than bulletin boards, but take the Facebook for example (not as complex as what they do but a good example, and the only i can think of at the moment). You can do a basic search for 'John' and the results returned will contain people named John, it will contain people who date a John, anyone who remotely has 'John' show up in any field in their profile.

Is the query for this simply a matter of a large amount of OR statements is there something else to it?


Thanks, happy holidays.

[earl-grey]

Can be that, but also can be fulltext search.

[jtucholski]

Does the fulltext search just work on individual fields, or does it work across a database? I've never used it before. I'll google it real quick but any short pieces of advice are always welcome. Thanks.

[jtucholski]

From the short time i spent looking at it, it says that 5.0 full text indexing is supported with MyISAM tables only. Does that mean we need to support our own referential integrity then?

[longneck]

yes

[r937]

tough call, isn't it? do you feel the need to squeeze every last picosecond of performance and penny out of your possibly limited webhosting resources, or would you prefer to have accurate data?

i kill myself sometimes

[jtucholski]

I'll take accurate data over it anytime.... I've seen some info regarding plugins to add fulltext search functionality.... i'll look into those.