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?