|
Code Listing 2: Running text query on text index
SELECT score(1), title, genre
FROM songs
WHERE CONTAINS(title, 'mice', 1) > 0;
This query should return a single row:
SCORE(1)TITLE GENRE
------- ----------------------- -----
5 The Preble Mice Go Squeak CHILD
|