On 3/6/07, Nils Meyer <[EMAIL PROTECTED]> wrote:
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
Hi Nils and all, I have gone through full text and here is a few limitations i find, 1. works only wiht MyISAM , now if i use innodb then ? anways this is not a major restrictions and can be removed, 2)Now i can not match within a word i mean the given word even in Boolean mode must start with the particular string word, even * would not work as the search string word should start with that, This is a major restriction. 3. i am not sure how to implement in joins. Pl. help, Thanks, Abhishek jain