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

Reply via email to