go to Sphinx instead, latest version supports sql like syntax
On Jun 26, 6:19 am, David <[email protected]> wrote:
> Hi,
>
> We use MySQL for our full text search. By default, MySQL ignores terms
> that are less than 4 characters long. In our search domain, though,
> 2-3 character terms are actually relevant to our users. It appears
> that there is a way to configure MySQL to accept terms that are less
> than 4 characters. I'm tempted to implement this, but am worried that
> there may be some unwanted side effects (e.g. "the", "and", "is", "as"
> all become valid search terms).
>
> Perhaps I should allow 2-3 character terms and just parse out stop
> words, but this may be an overly complex solution to a simple problem.
>
> Anyone here with some suggestions? Any input is gladly appreciated.
> Thanks!
>
> David,
> Web Developerwww.SexWorkers.co.nz(Not Safe for Work)
--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---