September 11, 2003 at 1:51 pm
Hi,
I am in the middle of developing procedure for keyword search for our website.
Input parameter is a string consisting keywords in comma delimited format.
This is the example of data I get from business group which I use to populate my key_search table.
product_id keyword
1 Microsoft, training
1 CA, DBA
1 CA, developer
1 CA, network admin
1 AZ, DBA
1 AK, developer
1 MN, DBA
1 MN, developer
1 OH, developer
2 Microsoft, training
2 AZ, DBA
2 AZ, developer
2 IL, developer
2 MN, DBA
2 CA, developer
2 NY, business analyst
2 NY, DBA
2 NY, developer
2 NY, programmer
3 Oracle, training
3 finance
4 Oracle demo
4 logistic
4 Oracle Financials
4 Financial Analyzer
They have provided search string examples like 'Microsoft, DBA, CA'
or 'CA'
or 'Microsoft, developer' or 'training'
I have script ready to remove comma from the string and store words from the input string in a temporary table.
But this is the easiest part.
The Confusing part now for me is to write the optimal code for retrieving the exact match from the key_search table as there is no limit on how many words can be in the string, it can be 1, 2, 3 or more.
Any suggestions on how should I handle this search?
September 11, 2003 at 1:57 pm
Is full text search an option?
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply