This content has been marked as final. Show 6 replies
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...
> 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???
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...
> 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".
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.
looks complicated for me......but i will read and learn it...
this really helps~~~~