indexing the entire large text column really drags performance down, and
consumes big hunks of disk space. mysql has a good regexp facility. rtfm
At 10:52 PM 7/6/01 -0700, you wrote:
>Hi Everyone,
>
>I'm writing a script using perl for a search function. I have a large
>text column that I want to scan for certain words. I do something like
>the following:
>
>select * from table_name where column_1 LIKE "%word1%" AND column_1 LIKE
>"%word2%";
>
>In this situation, words like 'tree' will return 'streets'.
>
>How can I find exact matches while still scanning the entire record? Are
>there any MySQL REGEX's that might help out. I'm considering indexing
>the entire column and compare my query against it but wanted to see if
>there were any other solutions out there.
>
>Thanks!
>Eric
>
>---------------------------------------------------------------------
>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
----------
tom marlin
[EMAIL PROTECTED]
fax / voice mail: 714 507 3802 ext 4881
Never be afraid to try something new. Remember that
- amateurs built the ark.
- professionals built the Titanic.
