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
