On 3/8/07, abhishek jain <[EMAIL PROTECTED]> wrote:
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
Hi, What if i use multiple like and not like statements for searching . Pl. reply, Thanks, Abhishek jain