On Sunday 29 December 2002 04:55, Frank Peavy wrote:
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
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
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
At 21:17 -0700 12/28/02, Mike Hillyer wrote:
I would think that using the fulltext search IN BOOLEAN MODE would return
results of any length, even 3 characters or less, check the bottom of
http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using
boolean mode.
Nope. IN BOOLEAN
Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
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
I would think that using the fulltext search IN BOOLEAN MODE would return
results of any length, even 3 characters or less, check the bottom of
http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using
boolean mode.
Mike Hillyer
-Original Message-
From: Frank Peavy
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:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject:
in sql use perl regular expression:
select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,2}$';
Jim
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words 3
: 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:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
thanks Mike,
I think i'll go climb another learning curve :-)
...
Jim
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:49 PM
To: JamesD; Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words 3 chars in 3.23
He wants
