Posted by Raj Shekhar on 03/24/05 22:37

"Ryan A" <ryan@coinpass.com> writes:

> Hey,
>
> > > I dont want to do that as its only mysql 4.1+ compatable,
> >
> > IN BOOLEAN MODE was added in version 4.0.1 not 4.1, for what it's
> > worth.
>
> Oops, thats what i meant. The problem is a LOT of hosts are still on 3.23.xx
> so I dont want to do the BOOLEAN MODE thing.


Here is the workaround that I used.

- If the search term is smaller than 3 words, I did a LIKE.

- If the search term is greater than 3 words, do a fulltext search
i.e. MATCH AGAINST (no BOOLEAN MODE)

- If the fulltext search did not find any results, do the search
again, but this time use LIKE instead of MATCH AGAINST.

This gave me good enough results.


--
Raj Shekhar Y! : Operations Engineer
MySQL DBA, programmer and slacker Y!IM : lunatech3007
home : http://rajshekhar.net blog : http://rajshekhar.net/blog/

• Next in forum: Re: [PHP] How can I destroy parameters by page
• Prev in forum: RE: [PHP] collapse SELECT from multiple tables
• Thread view: Re: Full-text searches sucks?

[Reply to this message]