i am trying to convert a MSSQL query into MySQL
I need to convert a query that I use in MSSQL into MySQL SELECT company_id, LTRIM(RTRIM(m.n.value('.[1]','varchar(8000)'))) AS [Proposal Number] FROM (SELECT company_id, p_number,CAST('<XMLRoot><RowData>' + REPLACE(replace(p_number,',', '/'), '/','</RowData><RowData>') + '</RowData></XMLRoot>' AS XML) AS x FROM…
