Retrieve Data After A Specific Carriage Return In A Text Column

[peterlaursen]

I also believe that this should be possible using string functions available here https://dev.mysql.com/doc/refman/5.6/en/string-functions.html. With respect to string parsing I don’t think MySQL is less capable than other RDBMS

 

One thing I could suggest is to SELECT HEX .. and use the string function on the hexadecimal string identifying linebreaks here, and extracting the substring you need.  Next UNHEX. It can still be done in a single statement by nesting UNHEX and HEX like “SELECT UNHEX(.. HEX ..)”. But there may be simpler solutions.

[Author]

Posts