List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 30 2002 5:40am
Subject:RE: Fulltext search of words < 3 chars in 3.23
View as plain text  
At 18:14 -0800 12/29/02, Frank Peavy wrote:
>Any one else with any suggestions? Remember, re-compile is out of 
>the question, it's a hosted site.
>Thanks.

If it's necessary to use FULLTEXT and not one of the other suggestions,
you're out of luck.  As Egor pointed out, you do this in 3.23 by
a source modification plus a recompile.  If you can't recompile,
you can't change the word length.

>
>
>At 10:49 PM 12/28/02 -0700, Mike Hillyer wrote:
>>He wants to execute a FULLTEXT search as opposed to a simple LIKE statement,
>>so I think REGEXP is out of the question.
>>
>>Mike Hillyer
>>
>>
>>-----Original Message-----
>>From: JamesD [mailto:jim@stripped]
>>Sent: Saturday, December 28, 2002 10:48 PM
>>To: Frank Peavy; mysql@stripped
>>Subject: RE: Fulltext search of words < 3 chars in 3.23
>>
>>
>>You need to use the REGEXP capability instead of "Like" in a where clause
>>
>>select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';
>>
>>Jim
>>
>>-----Original Message-----
>>From: Frank Peavy [mailto:fpeavy@stripped]
>>Sent: Saturday, December 28, 2002 6:55 PM
>>To: mysql@stripped
>>Subject: Fulltext search of words < 3 chars in 3.23
>>
>>
>>Does anyone have a method of performing fulltext searches on words less
>>than 3 characters on MySql 3.23? I am dealing with a web hosting company so
>>a re-compile is out of the question.
>>
>>Anyone have any good suggestions? I need to perform searches on acronyms
>>like "php".
>>Thanks.

Thread
Fulltext search of words < 3 chars in 3.23Frank Peavy29 Dec
  • RE: Fulltext search of words < 3 chars in 3.23Mike Hillyer29 Dec
    • RE: Fulltext search of words < 3 chars in 3.23Paul DuBois30 Dec
  • RE: Fulltext search of words < 3 chars in 3.23JamesD29 Dec
    • RE: Fulltext search of words < 3 chars in 3.23JamesD29 Dec
    • RE: Fulltext search of words < 3 chars in 3.23Mike Hillyer29 Dec
      • RE: Fulltext search of words < 3 chars in 3.23JamesD29 Dec
      • RE: Fulltext search of words < 3 chars in 3.23Frank Peavy30 Dec
    • RE: Fulltext search of words < 3 chars in 3.23Paul DuBois30 Dec
  • re: Fulltext search of words < 3 chars in 3.23Egor Egorov29 Dec