MySQL Forums
Forum List  »  Full-Text Search

returning ghost matches
Posted by: mister tapeworm
Date: April 11, 2009 09:04PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
returning ghost matches
3902
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.