Julien Lemoine wrote:
Steve Bennett wrote:
Just one more request: what about if the search string matches *within* the phrase, but not necessarily at the start. Like "Hardy" matching "Laurel and Hardy"? Is that possible with this data structure?
No it will not. But I don't think this will be really usefull : Imagine a query with a single letter ("a" or "e" for example), it will matches a least half articles without understanding the results.
Best Regards. Julien Lemoine
I wrote a "suggest" function for finding part numbers for a request form at work - enabling multi-word search is really useful and powerful. I haven't looked at your code, so I don't know if you're using a keyword index, or LIKE SQL functions. I set mine up to require at least 4 characters and to to break on whitespace, so the SQL (pseudocode) is WHERE LIKE(wordone) AND LIKE(wordtwo) and so on.
Best Regards, Aerik