geroid Posted October 17, 2009 Share Posted October 17, 2009 Hi I have a table called docs with 2 columns 'id' and 'text' and have inserted the following information INSERT INTO docs VALUES (1, ‘Oracle stuff’); INSERT INTO docs VALUES (2, ‘more Oracle stuff’); INSERT INTO docs VALUES (3, ‘SQL Server stuff’); COMMIT; I then run the following query as part of a college lab. I can't understand the output or what this query is asking. Can you help? The query is: SELECT SCORE(1) FROM docs WHERE CONTAINS (text, ‘Oracle’, 1) > 0; The output is: SCORE(1) ----------- 4 4 I don't understand what the two 4s refer to. Link to comment https://forums.phpfreaks.com/topic/178012-cant-understand-this-query-result-need-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.