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 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
To: [EMAIL PROTECTED]
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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
