Suppose we have table containing library books information.
I need to see whole list of books printed in 1999, but (it is most interesting!) sorting by presence (for example) "cars" and "vehicles" words.
How to make query in which I could see if (like some searchservices, altavista) both words present in title I will get 100%, if one of them - 50%, none- 0%.
Giedrius
Giedrius