Hi Ajo, Sorry for the late reply.
Actually the field-start an field-end modifiers introduced in version 0.9.9-rc2 of sphinx. http://www.sphinxsearch.com/docs/current.html for eg: ^hello$ will search exact match hello only. So I installed 0.9.9-rc2 sphinx and thats it. I had lot more requirements other than exact match. So there were lot more tricks in my code. Let me know did I answer your question. On Thu, Jul 15, 2010 at 3:48 AM, Ajo <[email protected]> wrote: > Hi Shiv, > > I'm having the same problem. How exactly did you solve it? > > thanks > > On Jul 12, 8:28 am, shiv singh <[email protected]> wrote: > > Hi Pat, > > > > Thanks for your reply. I solved the issue, actually I was using wrong > > version. > > FYI sphinx support ^ and $ [field start and end modifier (introduced in > > version 0.9.9-rc2)] > > > > *Regards, > > Shiv > > * > > > > > > > > On Wed, Jun 23, 2010 at 1:40 PM, Pat Allan <[email protected]> > wrote: > > > Hi Surya > > > > > I'm pretty certain Sphinx doesn't support regular expression matching - > and > > > I don't know any way to make exact matches take priority over partial > > > matches (you're not the first to ask for this). > > > > > So, in short: I'm not much help, sorry. > > > > > -- > > > Pat > > > > > On 22/06/2010, at 12:43 AM, surya wrote: > > > > > > Hi all > > > > I am a RoR developer, and I need your help to solve a issue in > > > > Thinking Sphinx. > > > > > > I have following indexes in method define_index in product table. > > > > indexes [la, tl], :as => :main_title > > > > indexes "CONCAT_WS(' ',REPLACE(la,'-',' '),REPLACE(tl,'-',' > > > > '),REPLACE(st,'-',' '))", :as => :whole_title > > > > indexes isbn13, cns2, cns3, bic2sc1, bic2sc2, bic2sc3, bic2sc4, > > > > bic2sc5, bic2st1, rare_pubpd#bic2st1 and rare_pubpd required for rare > > > > books > > > > indexes cns1, :as => :cns1, :sortable => :true > > > > indexes product_category.slug, :as => :product_category_slug > > > > > > now say I have few records in table as described here: > > > > id la , tl > > > > 1) "", "Johann Heinrich Voss Uber Des Virgilischen Landgedichts Ton > > > > Und Auslegung (1791)" > > > > 2) "", "Johann Heinrich Voss Uber Des Virgilischen Landgedichts Ton > > > > Und Auslegung (1791)" > > > > 3) "", "Briefwechsel Zwischen Heinrich Voss Und Jean Paul" > > > > 4) "", "Briefwechsel Zwischen Heinrich Voss Und Jean Paul" > > > > 5) "", "Voss" > > > > 6) "", "Talking Football : the 1997 Club 10 Afl Diaries of Wayne > > > > Carey, Glen Jakovich, Tony Lockett, Michael Voss and Gavin Wanganeen" > > > > > > And I do query in console > > > >>> Product.search('@main_title ^voss$', :match_mode => > :extended2).first > > > > or > > > >>> Product.search('@(main_title,whole_title) ^voss$', :match_mode => > > > :extended2).first > > > > or > > > >>> Product.search('@main_title ^voss$', :match_mode => > :extended2).first > > > > or > > > >>> Product.search('@(main_title,whole_title) ^voss$|voss', :match_mode > => > > > :extended2).first > > > > > > nothing is getting me the 5th record as a output. Infact ^voss$ > should > > > > match only one record but I get multiple records as output. > > > > > > What I want is : Exact matched record should come first followed by > > > > other records, which are not exactly matching title, but have the > word > > > > 'voss' somewhere in the title (i.e either in main_title or > > > > whole_title). > > > > > > Thanks in advance. > > > > > > Surya. > > > > > > -- > > > > 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]<thinking-sphinx%[email protected]> > <thinking-sphinx%2Bunsubscribe@ googlegroups.com> > > > . > > > > 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]<thinking-sphinx%[email protected]> > <thinking-sphinx%2Bunsubscribe@ googlegroups.com> > > > . > > > 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]<thinking-sphinx%[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.
