regexp_split_to_table ( substring(textvalue, 11, length(textvalue)-13), E'</value>\\u000A <value>')
Hasna
Posts: 1 New member
This query in PQSL
regexp_split_to_table ( substring(textvalue, 11, length(textvalue)-13), E'</value>\\u000A <value>') -- need to be converted to MYSQL
I tried using MYSQL substring_index()
but it doesnt resolved since i have to take this E'</value>\\u000A parameter<value>