Re: How to search?

MinZero wrote:
> 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.

Okee-dokee, what are the tables, exactly? What's your data model you're dealing with?

> I want to create a search box where a user can search
> between all their data for the match.

Okee-dokee, what data exactly?

> 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...

There are a variety of search engines, programs, models, etc. that might suit you. That's about all I can say given the tiny bit of information you've provided.

> Regards,
> Mike

As much as I hate to say it, and I don't mean to be rude, but I think before you can retrieve an answer that you like, you might have to be more specific in describing your situation.

On a happier note, maybe googling "search engine algorithm" might help.  Also search the newsgroups. You don't have to reinvent the wheel.

If you have a more "scary" agenda, like data-mining, building tons of reports, etc. Well then, I think you (and me!) might be better off hiring a DBA.

hth,
Todd Received on Wed Jan 04 2006 - 18:02:42 CST