Re: boolean search on phrase*

2006-10-14 Thread C.R.Vegelin
ns" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]> Sent: Thursday, October 12, 2006 2:58 PM Subject: Re: boolean search on phrase Hello: I may be going out on a limb, as I missed part of the thread; nevertheless, have you tried regular expressions? As

RE: Boolean search on phrase*

2006-10-12 Thread Jerry Schwartz
y Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Visolve DB Team [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 12, 2006 4:55 AM > To: C.R.Vegelin; mysql@lists.mysql.com > Subje

Re: boolean search on phrase*

2006-10-12 Thread C.R.Vegelin
;[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]>; Sent: Thursday, October 12, 2006 11:05 AM Subject: Re: boolean search on phrase* Hi, Try with + and * fulltext boolean operators. For instance, MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MO

Re: boolean search on phrase*

2006-10-12 Thread Visolve DB Team
ED]>; Sent: Thursday, October 12, 2006 4:08 PM Subject: Re: boolean search on phrase* Thanks ViSolve, So far I have tried the next alternatives, not giving me what I need: a) ... MATCH (Description) AGAINST('"olive oil"' IN BOOLEAN MODE) giving only "olive oil"

Re: boolean search on phrase*

2006-10-12 Thread C.R.Vegelin
rom: Visolve DB Team To: C.R.Vegelin ; mysql@lists.mysql.com Sent: Thursday, October 12, 2006 9:54 AM Subject: Re: boolean search on phrase* Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote ('"'), then the characters

Re: boolean search on phrase*

2006-10-12 Thread Visolve DB Team
Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote ('"'), then the characters matches only rows that contain the phrase literally, as it was typed. Try removing quotes. Thanks ViSolve DB Team. - Original Message - From: "C.R.Vegelin" <[