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
