First, set the format of the SELECT
statement's output so it is easily readable. Set the width of the text
column to 40 characters:
COLUMN text FORMAT a40;
Now query the table with the SELECT
statement with CONTAINS
. This retrieves the document IDs that satisfy the query. The following query looks for all documents that contain the word France:
SELECT SCORE(1), id, text FROM docs WHERE CONTAINS(text, 'France', 1) > 0; SCORE(1) ID TEXT ---------- ---------- ---------------------------------------- 4 3 <HTML>France is in Europe.</HTML> 4 2 <HTML>Paris is a city in France.</HTML>