So is there any other alternative. Thanks, Abhishek jain
On 3/10/07, Michael Dykman <[EMAIL PROTECTED]> wrote:
LIKE and NOT LIKE can be a dangerous path.. it is very easy to put yourself in a situation where your logic design requires full table scans for every query.. - michael dykman On 3/9/07, abhishek jain <[EMAIL PROTECTED]> wrote: > 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 > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful.