I have a json column with the following array:
[
{
"name":"Raj",
"email":"raj@gmail.com",
"age":32
},
{
"name":"Mohan",
"email":"Mohan@yahoo.com",
"age":21
}
]
I want to get an object whose name is Raj. Output :
[
{
"name":"Raj",
"email":"raj@gmail.com",
"age":32
}
]
Can you help me for MYSQL query for this?