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,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Recommended Answers
All 2 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Dani
4,084
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.