I did something like that 7 years ago. If you are serious about building google like search syntax, you need to build your own parser. I used JavaCC (Java compiler compiler) to define the grammer and dynamically buile the SQL where clause out of the parse tree. Regards Richard Ji On 3/13/07, abhishek jain <mail@xxxxxxxxx> wrote:
Hi Friends, I am having a database with varchar2(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"