Re: alternate in mysql

2009-09-07 Thread Ananda Kumar
Maybe? > > On Fri, Aug 21, 2009 at 10:13 AM, Jerry Schwartz < > jschwa...@the-infoshop.com> wrote: > >> >-Original Message- >> >From: Ananda Kumar [mailto:anan...@gmail.com] >> >Sent: Friday, August 21, 2009 2:55 AM >> >To: Johnny With

Re: alternate in mysql

2009-08-21 Thread Johnny Withers
. Maybe? On Fri, Aug 21, 2009 at 10:13 AM, Jerry Schwartz wrote: > >-Original Message- > >From: Ananda Kumar [mailto:anan...@gmail.com] > >Sent: Friday, August 21, 2009 2:55 AM > >To: Johnny Withers > >Cc: MySQL > >Subject: Re: alternate in mysql >

RE: alternate in mysql

2009-08-21 Thread Jerry Schwartz
>-Original Message- >From: Ananda Kumar [mailto:anan...@gmail.com] >Sent: Friday, August 21, 2009 2:55 AM >To: Johnny Withers >Cc: MySQL >Subject: Re: alternate in mysql > >Hi Johnny, >Thanks for the reply, but the below sql does not seems to work > > SELEC

Re: alternate in mysql

2009-08-20 Thread Ananda Kumar
Hi Johnny, Thanks for the reply, but the below sql does not seems to work SELECT * FROM tmp WHERE t REGEXP '^/sr/db/.*'; Empty set (0.02 sec) mysql> SELECT * FROM tmp WHERE t REGEXP '/sr/db/.*'; ++ | t

Re: alternate in mysql

2009-08-20 Thread Johnny Withers
You could try: SELECT * FROM tmp WHERE t REGEXP '^/sr/db/.*'; On Thu, Aug 20, 2009 at 9:15 AM, Ananda Kumar wrote: > Hi All, > I have this data in both oracle and mysql. > > select * from tmp; > T > -- > asdf > /sr/db/ora/ora.ora > asdfljk > asdlk