I got a idiotic question. in ASP I am doing a key word search using sql statement.
For example:
search for "computer".... results is fine. It gets only the records with the keyword like "%computer%"
search for "computer service"..... results comes out but not the way I want. my sql statement is like "%computer%" or like "%service%".
Its working. But I want to list the records with both keywords first and then list the other records with either keyword matching.
Any Idea....
For example:
search for "computer".... results is fine. It gets only the records with the keyword like "%computer%"
search for "computer service"..... results comes out but not the way I want. my sql statement is like "%computer%" or like "%service%".
Its working. But I want to list the records with both keywords first and then list the other records with either keyword matching.
Any Idea....