在mysql 5.5中解析JSON

I have a string stored as json in a mysql table. I need to parse the string and return the value within a stored procedure. I have a string stored as json in a mysql table