You can now execute queries using the defined topic instead of a complex query. For example, before you create the “saint-bernard” topic, you would have to use the following syntax:
...where i.index_any = "<accrue> (Saint Bernard, St. Bernard, working dogs, large dogs, European breeds)"
to find documents that:
Contain one or more of the following phrases: “Saint Bernard,” “St. Bernard,” “working dogs,” “large dogs,” and “European breeds”
Score documents containing the phrase “Saint Bernard” or “St. Bernard” higher than documents containing the phrase “working dogs,” “large dogs,” or “European breeds”
After you create the topic “saint-bernard”, you can use this syntax:
...where i.index_any = "<topic>saint-bernard"
...where i.index_any = "saint bernard"
If you enter a word in a query expression, the Full-Text Search engine tries to match it with a topic name. If you enter a phrase in a query expression, the Full-Text Search engine replaces spaces with hyphens (-), and then tries to match it with a topic name. For example, the Full-Text Search engine matches “saint bernard” with the topic “saint-bernard”.
See the sample_text_topics.sql file for examples of using topics in queries.