How can i convert Openxml() in sql to mysql i.e. alternative function for retrieve data from xml in Mysql

See more:

MySQL

Hello folks,


I have convert Sql stored procedure into mysql, I have converted all but for OPENXML,i don't find any alternative,
i have gooling but idon't understand that,

in that sp I have used in sql,

SET @pnvSyncCaseData = REPLACE(@pnvSyncCaseData,'xmlns="http://www./"','')
    SET @pnvSyncCaseData = REPLACE(@pnvSyncCaseData,'xmlns="http://www."','')
    SET @pnvSyncCaseData = REPLACE(@pnvSyncCaseData,'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"','')
    SET @pnvSyncCaseData = REPLACE(@pnvSyncCaseData,'soap:Envelope','Envelope')
    SET @pnvSyncCaseData = REPLACE(@pnvSyncCaseData,'soap:Body','Body')

EXEC sp_xml_preparedocument @idoc OUTPUT, @pnvSyncCaseData

INSERT INTO @LoanInfo
            (LoanNumber, HLP_CaseID)
        SELECT  LoanNumber, CaseID
        FROM OPENXML (@idoc,'Envelope/Body/RxGetCaseResponse/RxGetCaseResult/Details/LoanInformation',2)
        WITH (
                LoanNumber nvarchar(50),
                CaseID nvarchar(320)
            )

so i just want this is in mysql,

Please help me about that,
i required this on priority,

thanks in advanced