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:[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' 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 --------------------------------------------------------------------- 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
