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...
Subject
Views
Written By
Posted
Comma in boolean mode problem
5962
June 09, 2008 11:18AM
3506
June 09, 2008 11:52AM
3068
June 09, 2008 12:16PM
4145
June 09, 2008 02:13PM
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.