MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `campus_tb` (
 `campus_id` int(11) NOT NULL AUTO_INCREMENT,
 `campus_dataJSON` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`campus_dataJSON`)),
 PRIMARY KEY (`campus_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `campus_tb`( `campus_dataJSON`) VALUES ( '[
                          {"id":"100","u_email": "dr@kol.vop","name":"James","age":"17","course":"IT"},
                          {"id":"101","u_email": "meg@gmail.com","name":"Eric","age":"19","course":"CS"},
                          {"id":"102","u_email": "kitt@joko.com","name":"Julie","age":"21"}]');
INSERT INTO `campus_tb`( `campus_dataJSON`) VALUES ( '[
                          {"id":"100","u_email": "dr@kol.vop","name":"James","age":"17","course":"IT"},
                          {"id":"101","u_email": "meg@gmail.com","name":"Eric","age":"19","course":"CS"},
                          {"id":"102","u_email": "kitt@joko.com","name":"Julie","age":"21"}]');
SELECT CONCAT(REPLACE(SUBSTRING_INDEX(JSON_SEARCH(`campus_dataJSON`, 'one', 'meg@gmail.com'),'.',1),'"',''),'.admitted') FROM campus_tb;


CONCAT(REPLACE(SUBSTRING_INDEX(JSON_SEARCH(`campus_dataJSON`, 'one', 'meg@gmail.com'),'.',1),'"',''),'.admitted')


$[1].admitted

$[1].admitted


UPDATE campus_tb
SET `campus_dataJSON` = 
JSON_INSERT(`campus_dataJSON`, CONCAT(REPLACE(SUBSTRING_INDEX(JSON_SEARCH(`campus_dataJSON`, 'one', 'meg@gmail.com'),'.',1),'"',''),'.admitted'), 'YES')
WHERE campus_id = 3;

Rows matched: 1  Changed: 1  Warnings: 0


UPDATE campus_tb
SET `campus_dataJSON` = 
 JSON_INSERT(`campus_dataJSON`, '$[1].admitted', 'YES')
WHERE campus_id = 2;

Rows matched: 1  Changed: 1  Warnings: 0


SELECT * FROM `campus_tb`


campus_id
campus_dataJSON


2
5b7b226964223a2022313030222c2022755f656d61696c223a20226472406b6f6c2e766f70222c20226e616d65223a20224a616d6573222c2022616765223a20223137222c2022636f75727365223a20224954227d2c207b226964223a2022313031222c2022755f656d61696c223a20226d656740676d61696c2e636f6d222c20226e616d65223a202245726963222c2022616765223a20223139222c2022636f75727365223a20224353222c202261646d6974746564223a2022594553227d2c207b226964223a2022313032222c2022755f656d61696c223a20226b697474406a6f6b6f2e636f6d222c20226e616d65223a20224a756c6965222c2022616765223a20223231227d5d

3
5b7b226964223a2022313030222c2022755f656d61696c223a20226472406b6f6c2e766f70222c20226e616d65223a20224a616d6573222c2022616765223a20223137222c2022636f75727365223a20224954227d2c207b226964223a2022313031222c2022755f656d61696c223a20226d656740676d61696c2e636f6d222c20226e616d65223a202245726963222c2022616765223a20223139222c2022636f75727365223a20224353222c202261646d6974746564223a2022594553227d2c207b226964223a2022313032222c2022755f656d61696c223a20226b697474406a6f6b6f2e636f6d222c20226e616d65223a20224a756c6965222c2022616765223a20223231227d5d


UPDATE campus_tb
SET `campus_dataJSON` =  JSON_REPLACE(`campus_dataJSON`, '$[2].age', 25)
WHERE campus_id = 2;

Rows matched: 1  Changed: 1  Warnings: 0


UPDATE campus_tb
SET `campus_dataJSON` 
=  JSON_REPLACE(`campus_dataJSON`, CONCAT(REPLACE(SUBSTRING_INDEX(JSON_SEARCH(`campus_dataJSON`, 'one', 'kitt@joko.com'),'.',1),'"',''),'.age'), 25)
WHERE campus_id = 3;

Rows matched: 1  Changed: 1  Warnings: 0


SELECT * FROM `campus_tb`


campus_id
campus_dataJSON


2
5b7b226964223a2022313030222c2022755f656d61696c223a20226472406b6f6c2e766f70222c20226e616d65223a20224a616d6573222c2022616765223a20223137222c2022636f75727365223a20224954227d2c207b226964223a2022313031222c2022755f656d61696c223a20226d656740676d61696c2e636f6d222c20226e616d65223a202245726963222c2022616765223a20223139222c2022636f75727365223a20224353222c202261646d6974746564223a2022594553227d2c207b226964223a2022313032222c2022755f656d61696c223a20226b697474406a6f6b6f2e636f6d222c20226e616d65223a20224a756c6965222c2022616765223a2032357d5d

3
5b7b226964223a2022313030222c2022755f656d61696c223a20226472406b6f6c2e766f70222c20226e616d65223a20224a616d6573222c2022616765223a20223137222c2022636f75727365223a20224954227d2c207b226964223a2022313031222c2022755f656d61696c223a20226d656740676d61696c2e636f6d222c20226e616d65223a202245726963222c2022616765223a20223139222c2022636f75727365223a20224353222c202261646d6974746564223a2022594553227d2c207b226964223a2022313032222c2022755f656d61696c223a20226b697474406a6f6b6f2e636f6d222c20226e616d65223a20224a756c6965222c2022616765223a2032357d5d