What are the challenges you face when working across database platforms? Take the survey
Options

regexp_split_to_table ( substring(textvalue, 11, length(textvalue)-13), E'</value>\\u000A <value>')

HasnaHasna Posts: 1 New member
-1

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>

Sign In or Register to comment.