How do i view TYPE_SERIALIZED data

[arms]

I'm looking for a particular entry.

how do I parse in mysql?

 

[Lawrence]

Select the data you want to view. Then press Export -> Select Custom -> Output (select View output as text). Scroll to the bottom and uncheck Dump Binary columns as hexidecimal, and then press the Go button.

 

[arms]

Thanks @Lawrence, copied table and then dropped all other fields and was able to then view all as you described. would never of unchecked that tick at the bottom in phpmyadmin (as i use HeidiSQL, and it doesn't seem possible )