1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How do i view TYPE_SERIALIZED data

Discussion in 'General PHP and MySQL Discussions' started by arms, Mar 29, 2014.

  1. arms

    arms Active Member

    I'm looking for a particular entry.

    how do I parse in mysql?
  2. Lawrence

    Lawrence Well-Known Member

    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 likes this.
  3. arms

    arms Active Member

    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 :D)

Share This Page