Hello Friends,

Actually i am Sticken with a very peculiar problem, related to search

Actually i have a database with a column "Description" which has a long strings of 1000 characters describing about the produts of the company

for E.g. "We are manufcaturers of Plastic Raw material, platic containers, Elctrical items Etc.............." & so on.

so, the problem is that i want when some person search for particular item, i want to show them in the relevance order

for e.g.
somebody searches for "plastic container & raw material"

so i want the record to search for "plastic", "plastic container", "raw material", & "plastic raw material" and single words like "plastic", "Container", "Raw", "Material"

after the searching i want to put them in relevant order
-such as the string which contain the actual term should be at top
-String containing maximum number of keywords should be placed afetr that
-string contining all the single letters should be placed at last

Please help me
i can configure my database as per the requirement,
i am sticken at this point of time.

Hoping to get some better response from you folks

"Thanks" IN ADVANCE

from

Vikram Sachdeva

Hi,

Your problem regarding searching is base on sql.
by the help of good sql query you can search any records which
you want to search.

it will better that you post your question at Wrox SQL Forum
hope that you will get better response.

regards

Mateen