Re: Can't search words of three letters?

I ca try that one too. Since, I'm bad with reg expressions, what would be solution for something like "match searched word and it's plural - if one word entred, or match all words - if more words entered"? thanks -afan > Why not try regex? > > http://dev.mysql.com/doc/refman/4.1/en/regexp.html

Re: Can't search words of three letters?

On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi to all, hi I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt". > I was suggested to use MATCH() AGAINST() and it works perfect

Re: Can't search words of three letters?

Why not try regex? http://dev.mysql.com/doc/refman/4.1/en/regexp.html On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi to all, > I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt"

Can't search words of three letters?

Hi to all, I have to build a search of products on web catalog site. It has to search a whole words to avoid when somebody search for a pin and get "*pin*k shirt". I was suggested to use MATCH() AGAINST() and it works perfect - until I dscovered that I'm getting alwayes 0 results if search for cap,