Re: Google like search string to be implemented
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.
Re: Google like search string to be implemented
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
Re: Google like search string to be implemented
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
Re: Google like search string to be implemented
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]
Re: Google like search string to be implemented
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
Google like search string to be implemented
Hi Friends, 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 As you can see the word/words prefixed with + should be there somewhere in the above columns in database ,with - should not be there and within they should be exact phrase. I want a sol. for this, Pl. help me how to make a search queruy will it be in regex or simople like and not like , i will be having about 1 lac records in the database. Thanks, Abhishek jain