Re: Google like search string to be implemented
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: mail@xxxxxxxxx, Ghassan Salem <salem.ghassan@xxxxxxxxx>
- Date: Wed, 14 Mar 2007 11:03:28 +0000 (GMT)
Hi
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3723269461014
regards
Hrishy
--- abhishek jain <mail@xxxxxxxxx> wrote:
> Hi,
> Yes i know but there are two problems:
> 1. I am using an earlier version
> 2. How to make the regex capable for this, i can
> make in PERL but that great
> support i think is not available in oracle.
> Thanks,
> Abhishek
>
>
> On 3/13/07, Ghassan Salem <salem.ghassan@xxxxxxxxx>
> wrote:
> >
> > If you're on 10g, there is the regexp functions
> that handle regular
> > expression manipulation, have a look at them
> >
> > rgds
> >
> > 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"
> > > 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.
> > > I have adequate exp with mysql but not with
> Oracle , pl. help i need to
> > > implement this on Oracle.
> > > Thanks,
> > > Abhishek jain
> > >
> >
> >
>
___________________________________________________________
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at
the Yahoo! Mail Championships. Plus: play games and win prizes.
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
--
//www.freelists.org/webpage/oracle-l
Other related posts:
