Full Text search in Database

[ky_loh]

I got problem here.......
i have few table in DB, n i wanna to search all field to match ONE keyword....what is ur's advise???

and later i wanna to do multiple keyword search, how i can do it??

if DB growth very huge~~~like 2million entries......how should manage???

hope ur can give me advise...TQ

[sTg]

If you optimize the database indexes pretty advanced and searches in many records can work. In your case it sounds like using verity would be the best solution. Searching every field in multiple tables for one or more keywords is not a very good thing...

[Newsgroup_User]

ky_loh wrote:
> I got problem here.......
> i have few table in DB, n i wanna to search all field to match ONE
> keyword....what is ur's advise???

what db?

[ky_loh]

MySQl and MSSQL

can i have the normal pratice procedure that normally you doing???

like what ned to configure in DB, such as view?? or something...

[Newsgroup_User]

ky_loh wrote:
> MySQl and MSSQL
>
> can i have the normal pratice procedure that normally you doing???

for ms sql server i use full text indexing. you can use CONTAINS, CONTAINSTABLE,
FREETEXT or FREETEXTTABLE predicates depending on what you need (the CONTAINS
predicates search for precise or fuzzy matches to words or phrases, the FREETEXT
ones searches for meanings & not exact wording, the CONTAINSTABLE and
FREETEXTTABLE return tables instead of rowsets which is useful if you have to
join the results to something).

something like this will search thru all the columns that you have full text
indexed for rows where the word "bean" is "near" the word "curd".

SELECT Description
FROM Categories
WHERE CONTAINS(*, 'bean NEAR curd')


> like what ned to configure in DB, such as view?? or something...

for ms sql server it's explained quite well in it's Books-on-Line. search for
"Full-text Querying SQL Server Data".

no idea about mysql.

[drforbin1970]

Check out these URLs:

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=649&lngWId=5
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

[ky_loh]

looks complicated for me......but i will read and learn it...
this really helps~~~~

Thanks guy~~~~