Hi Neil It may be that you need to add the @ symbol to your charset_table, to ensure it gets indexed as a word character. I'm guessing that the default is it's ignored by Sphinx's indexer?
See here: http://sphinxsearch.com/docs/manual-2.0.6.html#conf-charset-table And two-thirds down this page: http://pat.github.com/ts/en/advanced_config.html Thinking Sphinx defaults to using the utf-8 charset_type (and thus, the default utf-8 charset_table values). Cheers -- Pat On 08/01/2013, at 8:09 PM, Neil wrote: > The plan is to use Thinking Sphinx to search for @Replies and @Mentions > within a messages.content column, but at present Sphinx is also returning > "UserName" matches alongside "@UserName": > > @Replies (Only return Messages where messages.content begins with > "@UserName"): > Message.search("^\\@#{user_name}") > > @Mentions (Only return Messages where messages.content contains "@UserName" > but does not being with "@UserName"): > Message.search("\\@#{user_name}", conditions: { content: "!^\\@#{user_name}" > }) > > Does anyone know how to filter out the "UserName" matches and to only return > "@UserName" in both cases? > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/crUUOWFC_soJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
