Targetting elements of an array that are JSON data type?

Hey everyone,

I'm currently stuck at this problem which is say I have the following table created:

CREATE TABLE employees(data JSON);

INSERT INTO employees(data) VALUES
('{"name": "greg", "age": 25}'), ('{"name": "james", "age": 30}'),
('{"name": "jane", "age": 45}'), ('{"name": "alex", "age": 50}'),
('{"name": "bill", "age": 29}'), ('{"name": "tom", "age": 65}');


UPDATE employees SET data = JSON_INSERT(data, '$.hours', JSON_ARRAY(8,10,12,16,11));

Let's say I want to delete from that hours array inside the JSON data type where the hour = 8. How can I do this? The only way I know to remove an element from an array is knowing the exact position

which I would do something like this:

UPDATE employees SET data = JSON_REPLACE(data, '$.hours', JSON_REMOVE(JSON_EXTRACT(data,'$.hours'), '$[0]'))
WHERE JSON_EXTRACT(data,'$.name') = 'greg';

Is there anyway I could just search for this 8 without giving a position? I'm in the process of trying to learn it I've written a little article keeping notes on how I can use it at http://www.nowakowskig.com/blog/mysql-5-7-native-json-tutorial-nosql