returning ghost matches
I'm using the following query:
SELECT `id`, `title`, `body` FROM `threads` WHERE `id` IN (SELECT `id` FROM `threads` WHERE MATCH(`title`, `body`) AGAINST ('
http://www.websitethatdoesnotexist.com'; IN BOOLEAN MODE) UNION SELECT `threadid` FROM `posts` WHERE MATCH(`body`) AGAINST ('
http://www.websitethatdoesnotexist.com'; IN BOOLEAN MODE) AND `valid` = 'Y')
query works fine, in all ways possible EXCEPT, for some reason searching for a web address (like the one above) which is not referenced anywhere in my database causes the query to return a large number of results when there should be none... why?
Subject
Views
Written By
Posted
returning ghost matches
3966
April 11, 2009 09:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.