Data stored in json

I have my data stored in a JSON string like the开发者_开发技巧se...

a:1:{s:15:"s2member_level1";s:1:"1";}

How can i read this values in mysql?

I need to know if the value "s2member_level1" is 1.

Thanks!!!

That's not JSON but a string resulted from calling serialize() in PHP. You cannot parse it easily in MySQL. If you can use PHP, use the unserialize function:

$obj = unserialize($data_from_mysql);
if ($obj['s2member_level1'] == 1) {
    // more code here
}

You can convert data to JSON in PHP using the json_encode function. In a similar way, you construct an object from a JSON string using json_decode.

@Lekensteyn is correct, but you could do a like statement, although its performance would most likely be very poor. My true answer is to change how you store this information to take advantages of best performing queries.

select * from table
where column like '%s:15:"s2member_level1";s:1:"1";%';

@Lekensteyn is right about the type of this particular String, but for others, PHP has json_decode which you can use to convert a JSON object to a PHP object. It would be considerably more difficult to read such an object using MySQL only.

This is no json, but serialized data. It was probably serialized with the 'serialize' function of PHP. Try:

print_r(unserialize('a:1:{s:15:"s2member_level1";s:1:"1";}'));

... to unserialize it.