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?
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.