This question already has an answer here:
I have a column contain json data,
{
"city":"\u0628\u063a\u062f\u0627\u062f",
"town":"\u0627\u0644\u0627\u0639\u0638\u0645\u064a\u0629",
"queue":"316",
"lane":"22",
"home":"15"
}
how can I search on the object (town) in the table? I have tried
$query ="SELECT * FROM tabel WHERE JSON_CONTAINS(colom_name,'town') like '%$Word%' order by id DESC";
Also There are no results at all
</div>