On 3/6/07, abhishek jain <[EMAIL PROTECTED]> wrote:
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
Hi guys, Pl. reply and give an alternative which i can use to include a partuial word in mine search string which i can match in a table coumn, Thanks, Abhishek jain