SQL - Keyword searching / partial match

[danielleissy]

Firstly i would like to know the difference between Keyword searching using SQL and partial matching of a search.

I have to search for a book by key word in the book title. But allow TWO key words in the Query.

This is what i have:

SELECT *
FROM Books
WHERE Title LIKE '*Nature*' OR Title LIKE '*Britain*';

This is searching for the book "The Nature of Britain.

However i feel this is wrong somehow and i should b doing it another way. Please Help.
Thanks

[MikeTheBike]

Firstly i would like to know the difference between Keyword searching using SQL and partial matching of a search.

I have to search for a book by key word in the book title. But allow TWO key words in the Query.

This is what i have:

SELECT *
FROM Books
WHERE Title LIKE '*Nature*' OR Title LIKE '*Britain*';

This is searching for the book "The Nature of Britain.

However i feel this is wrong somehow and i should b doing it another way. Please Help.
Thanks

Hi
If you want to return all recorords with both nature AND britain (in that order) in the tiltle then pehaps this:

SELECT *
FROM Books
WHERE Title LIKE '*Nature*Britain*';

If you want to return all recorords with both nature AND britain (but in any order) in the tiltle then pehaps this:

SELECT *
FROM Books
WHERE Title Like '*Nature*' AND Title Like '*Britain*';

Your origional query returns all books with nature OR britain in the title.

MTB

[danielleissy]

Thanks that helps, But is this called a 'Keyword' search, because i have another problem which is very similar.

I have to search for a book by its author.
But it states that i should allow partial matching of the Authors names.

All i have done for this is the same as above.
But there must be a difference between partial matching a search and a keyword search.

Many Thanks.

[MikeTheBike]

Thanks that helps, But is this called a 'Keyword' search, because i have another problem which is very similar.

I have to search for a book by its author.
But it states that i should allow partial matching of the Authors names.

All i have done for this is the same as above.
But there must be a difference between partial matching a search and a keyword search.

Many Thanks.

I think to Like operator with the asterisk does precisely what you want. Try serching in Help for 'Like Operator' for a full explanation of its capabilities.

MTB