sql - What to use in place of 'For XML' (in MsSql) to MySQL?

Question

I have a VIEW written in Microsoft SQL Server which has some statements like "For XML Path (' ') '... in select statement. I have to migrate this VIEW to MySQL view. In MySQL this statement is throwing error. So my question is what to use in place of For XML??

Here's a line from the actual code-:

Select .......,
Substring (select ';' + Domain.Dom as [text()] from 
(Select CD.Domaindescription + '('  + CD.Domaincode + ')' as DOM from Conf_Domain CD
 inner join 
GDA_User_Profile_Access GUPA on GUPA.Domainid = CD.Domainid and GUPA.Userprofileid = P.Userprofileid
) As Domain For XML Path (' ')),2,1000) as UPDomain,
............

How to modify it to MySQL code??

Answer 1

Waitting for answers