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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.