MySQL Forums
Forum List  »  Full-Text Search

Comma in boolean mode problem
Posted by: mally one
Date: June 09, 2008 11:18AM

I have a small cg blog and am currently migrating from 4.1 so I hope this is in the right area. I'm trying to do a boolean search on mysql 5.0.51a-3 on ubuntu which previously worked in 4.1 but now seems to be getting hung up on the comma.

Some reading has shown that the comma is one of the "stop chars" that delimits words, but in this case, it's wanted as part of the phrase, while maintaining it's function as a stop char for most of the rest of the index. How/Is this possible?

Here are two examples, the first searching without double quotes, the second with double quotes, both return empty result sets:

SELECT distinct title.upc, title.name
FROM titles as title
WHERE MATCH (title.name)
AGAINST ('10,000 BC' IN BOOLEAN MODE)

SELECT distinct title.upc, title.name
FROM titles as title
WHERE MATCH (title.name)
AGAINST ('"10,000 BC"' IN BOOLEAN MODE)


Thanks in advance :).

m1...

Options: ReplyQuote


Subject
Views
Written By
Posted
Comma in boolean mode problem
5892
June 09, 2008 11:18AM
3031
June 09, 2008 12:16PM


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.