Mysql Where JSON Field

"SELECT fee, 
SUM(CASE WHEN JSON_VALID(fee) THEN JSON_EXTRACT(fee, '$.\"$rw->nohp\"') ELSE null END) as fee from pls_trx where left(stamp,7)='$bln' and status !='Gagal'"

or

		/*
		$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 !=''
			and  JSON_VALID(kelas) 
			GROUP BY SUBSTRING_INDEX(vv -> '$.\"info\"','-', 1)
			ORDER BY vv->'$.\"info\"' ASC",2)
		*/
		$siswas=loadsql("SELECT JSON_EXTRACT(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 !=''
			and  JSON_VALID(kelas) 
			GROUP BY SUBSTRING_INDEX(JSON_EXTRACT(vv,'$.\"info\"'),'-', 1)
			ORDER BY SUBSTRING_INDEX(JSON_EXTRACT(vv,'$.\"info\"'),'-', 1)",2)