Re: How to search?
Date: Thu, 5 Jan 2006 13:36:19 +0200
Message-ID: <dpj0bo$11f$1_at_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 - 12:36:19 CET