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 | +----------------------------------------------------+ | asdf /sr/db/ora/ora.ora /sr/db/ora/aaa.ora asdlkjf | On Thu, Aug 20, 2009 at 8:19 PM, Johnny Withers <joh...@pixelated.net>wrote: > You could try: > > SELECT * FROM tmp WHERE t REGEXP '^/sr/db/.*'; > > On Thu, Aug 20, 2009 at 9:15 AM, Ananda Kumar <anan...@gmail.com> wrote: > >> Hi All, >> I have this data in both oracle and mysql. >> >> select * from tmp; >> T >> -------------------------------------------------- >> asdf >> /sr/db/ora/ora.ora >> asdfljk >> asdlkjf >> >> asdf >> /sr/db/ora/ora.ora >> /sr/db/ora/aaa.ora >> asdlkjf >> Where t is a varchar column, with each row having multiple lines. >> I can write this query in oracle to fetch only rows starting with ''sr/db" >> >> select substr(t, instr(t, '/sr/db/'), instr(substr(t, instr(t, '/sr/db/'), >> length(t)), chr(10))) from tmp; >> /sr/db/ora/ora.ora >> /sr/db/ora/ora.ora >> where chr(10) ..represents "NEW LINE" in oracle >> >> How do i do the same in mysql. >> >> Thanks for all you help. >> >> regards >> anandkl >> > > > > -- > ----------------------------- > Johnny Withers > 601.209.4985 > joh...@pixelated.net >
