CREATE TABLE t1 (name varchar(255) , secondary_pitch JSON);
INSERT INTO t1 VALUES('Chris Sale', '["Curveball","Slider"]');
INSERT INTO t1 VALUES('Aldoris Chapman', '[]');

select *,JSON_EXTRACT(secondary_pitch, '$[0]')
from t1
where JSON_EXTRACT(secondary_pitch, '$[0]') is not null