No, the first asterix is ignored. B)
AJ Mercer wrote: > would you need a Astrix both sizes of 'eagle'? > freetext(companyName, '"*eagle*"') > > > On 7/6/07, *Brett Payne-Rhodes* < [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > > Sure... > > select companyName, companyState from companyDetails > where freetext(companyName, '"eagle*"') and companyState = 'WA' > order by companyName > > Returns 121 rows in 2 seconds > > While... > > select companyName, companyState from companyDetails > where companyNamelike '%eagle%' and companyState = 'WA' > order by companyName > > Return 149 rows in 25 seconds > > > So the performance increase is there, but the results aren't what I > was expecting. > > My impression is that the full-text search looks for the word > 'eagle' and a few variations like 'eagles' but does not pick up > versions such as 'eaglehawk'. > > > Thanks, > > Brett > B) > > > Taco Fleur wrote: > > Can you post your SQL? > > > > On 7/6/07, *Brett Payne-Rhodes* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > <mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote: > > > > > > I'm trying to speed up a wildcard search on a text field > along the > > lines of SELECT companyName from companyDetails where companyName > > like '%eagle%' > > > > The database is mssql 2005 and the table has over two million > rows. > > > > What I have already done is to create a full-text index on > > companyName and while it does appear to run faster, the results > > generated by the query using the full-text index aren't even > nearly > > the same as the results of the wildcard query in that the > wildcard > > search picks up 'eaglehawk' but the full-text query doesn't, > even > > using "eagle*". > > > > Can anyone explain this for me or point me to a reference > that will > > help? > > > > Thanks and sorry for the OT but I thought other people here > might be > > interested. > > > > Brett > > B) > > > > > > http://www.clickfind.com.au > > The new Australian search engine for businesses, products and > services > > > > > > > > > -- > If you are not living on the edge, > You are taking up too much space. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" 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/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
