Re: Fulltext boolean search and the asterix

2005-11-11 Thread Jigal van Hemert
Paul DuBois wrote: At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? To use a literal instance of a special character in a regular expression, precede it by

Re: Fulltext boolean search and the asterix

2005-11-09 Thread Paul DuBois
At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. The manual comes

Re: Fulltext boolean search and the asterix

2005-11-08 Thread Jigal van Hemert
Lindsey wrote: Lets say the table contains the following brands SAMSUNG SIEMENS SONY If you do a fulltext boolean search with the term: -S*Y -(S*Y) everyting that starts with an S will be excluded... any solutions? Although I couldn't find a question in your post, I guess you want to know

Re: Fulltext boolean search and the asterix

2005-11-08 Thread Lindsey
ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. Quoting Jigal van Hemert [EMAIL PROTECTED]: Lindsey wrote: Lets say the table

Re: Fulltext boolean search and the asterix

2005-11-08 Thread Jigal van Hemert
Lindsey wrote: ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. The manual comes again to the rescue ;-) Appendix G [1] tells

Fulltext boolean search and the asterix

2005-11-07 Thread Lindsey
Lets say the table contains the following brands SAMSUNG SIEMENS SONY If you do a fulltext boolean search with the term: -S*Y -(S*Y) everyting that starts with an S will be excluded... any solutions? -S*Y will return all. - FREE E-MAIL IN 1