Hi,
abhishek jain wrote:
I am having a database with varchar(255) columns named title,
extra_info1,extra_info2,extra_info3 .
I want to search all these columns with a search string given to me via a
form ,I am using PERL, the string will be like
+abhishek jain -abcd "this should be exact"
I think MySQL fulltext search in boolean mode would be the perfect
choice for that:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
You can use search strings like your example with that directly.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
