We store a list of keywords in the database as a comma-delimited string. I want to use Sphinx to query against the field, but I'm worried that the keywords would all be treated as a single word since there are no spaces. I went ahead and edited the MySQL query in the sphinx.conf file to SELECT REPLACE(keywords, ',', ' ') so that they would each be recognized as individual words, but is this necessary? How does Sphinx treat commas (and other punctuation, for that matter) and are they treated differently than spaces?

5 Years
Discussion Span
Last Post by Dani

Thanks ... It says that the charset table can be used to give a comma-delimited list of characters to be indexed, but not about whether it's possible to escape the comma character in this comma-delimited list.

Still curious as to whether a comma is treated like a space or indexed by default.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.