Re: How to search?

From: x <x_at_not-exists.org>
Date: Thu, 5 Jan 2006 13:36:19 +0200
Message-ID: <dpj0bo$11f$1@domitilla.aioe.org>

"MinZero" <akiany_at_gmail.com> wrote in message news:1136229285.301114.35870_at_g44g2000cwa.googlegroups.com...
> I am new in this field and would appreciate it if someone points me to
> the right direction.
>
> I have a website with lots of users and each have lots of data in
> multiple tables. I want to create a search box where a user can search
> between all their data for the match. I want to search system to
> contain multiple words and be forgiving. How do I do it? Do I have to
> create a flat text of every record in my tables and then run the search
> through them for every word entered? That doesn't sound right? It would
> exhaust my database with a few users...

If you can maintain a table T(database, table, rowid, value) indexed on (value, database) instead of the flat text file would be better ? Received on Thu Jan 05 2006 - 05:36:19 CST