mysql sort on json column

$siswas=loadsql("SELECT kelas -> '$.\"$user->tahun\"' AS vv,
			SUM(CASE WHEN kelamin like 'L%' or kelamin like 'l%' THEN 1 ELSE 0 END) l, 
			SUM(CASE WHEN kelamin like 'P%' or kelamin like 'p%' THEN 1 ELSE 0 END) p, 
			sum(case when kelamin !='' then 1 else 1 END) jml 
			from ".$user->owner."_dasis 
			where owner='$user->owner' and tgl_keluar ='' AND kelas !=''
			GROUP BY SUBSTRING_INDEX(vv -> '$.\"info\"','-', 1)
			ORDER BY vv->'$.\"info\"' ASC",2)

atau juga boleh begini

$rs=loadsql("select ".$user->owner."_trx.*,".$user->owner."_dasis.nama as nama2, ".$user->owner."_dasis.kelas -> '$.\"$user->tahun\"' AS vv
					from ".$user->owner."_trx left join ".$user->owner."_dasis
					on ".$user->owner."_trx.nis = ".$user->owner."_dasis.nis
					where ".$user->owner."_trx.owner='$user->owner' $bulanan $get->cat and bayar='' order by JSON_EXTRACT(vv, '$.info') ASC"

other case with this data

+-------------------------------+
| data                          |
+-------------------------------+
| {"id": "4", "name": "Betty","mobile_no.":"921213"}  |
+-------------------------------+

SELECT JSON_EXTRACT(data,'$.name') AS  name FROM users