From: Ananda Kumar
Date: August 20 2009 2:15pm
Subject: alternate in mysql
List-Archive: http://lists.mysql.com/mysql/218442
Message-Id: <829b199c0908200715v2312658eu74162ef26310307@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=000e0cd4871cd43144047193616d

--000e0cd4871cd43144047193616d
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--000e0cd4871cd43144047193616d--