Search Result for anything that containt 'x' word

[erickwidya]

right now i want to develop searching mechanism, it sound like google..so user type some words and the program will search for any column in certain table(or maybe entire tables in Database) and display the result..

can i use something like that in SQL Server 2005?

needs some idea

thanks,

[VBFnewcomer]

See if the attachment helps

[erickwidya]

thanks VBNewComer,

but that's not what i mean, u just search based on "CompanyName" while the searching i mean is for whole field in whole table in one Database

just like google mechanism, type once but it's for all the criteria above..

i think it involved using Full Text Search...

still need to digg it more

[si_the_geek]

I seriously doubt that Google searches multiple columns - I would expect them to have a single column for search words.

To be able to search multiple columns, you need to use multiple conditions, eg:

WHERE Field1 = Value
   OR Field2 = Value
   OR Field3 = Value

You may find that Full Text Search is useful, I've never found a need for it myself so can't remember exactly what it does.

[erickwidya]

thanks si

I seriously doubt that Google searches multiple columns - I would expect them to have a single column for search words -> maybe, what i'm thinking is because they can dispay same url for different keywords

To be able to search multiple columns, you need to use multiple conditions -> yes..but i ended up using many OR conditions

You may find that Full Text Search is useful, I've never found a need for it myself so can't remember exactly what it does. -> i'll inform what i found later

[si_the_geek]

I seriously doubt that Google searches multiple columns - I would expect them to have a single column for search words

-> maybe, what i'm thinking is because they can dispay same url for different keywords

I expect they have one table for the keywords, one for page data (such as URL), and one for KeywordsPerPage - which would contain the ID's from the other two tables (one row for each keyword on a page).

The search (ignoring the ranking process!) would theoretically be in two stages, find the ID's for the Keywords, and then search KeywordsPerPage by those ID's.


Admittedly they probably use data-warehouse techniques rather than a standard relational model, but it would still only involve one keyword column.

[dee-u]

Have a search for GetSchema, it will return important datas like tables and columns which you may query against.

[erickwidya]

thanx dee-u, i'll take a look

Full Text Search can do what i need

With full-text searching, you can perform many other types of search:

* Two words near each other
* Any word derived from a particular root (for example run, ran, or running)
* Multiple words with distinct weightings
* A word or phrase close to the search word or phrase

u can read it more here

[khab00key]

deleted-

[si_the_geek]

Welcome to VBForums

Please do not add your questions to other peoples threads - especially when the thread topic is almost completely irrelevant to what you are doing (while there is a minor element of similarity, there are massive differences in the language etc).

As your question is about the VB Editor in Excel (which is VBA rather than VB), you should post a new thread in our Office Development forum

[Pradeep1210]

You may find that Full Text Search is useful, I've never found a need for it myself so can't remember exactly what it does.

Normally you can't index a varchar/char field which is more than 900 characters in length. The full text search comes into this scene. It can index large text fields and also has its own support keywords for searching thru that data.