Using JSON Search Index with JSON_EXISTS
Find JSON enabled data.
select customer_info from customers
where JSON_EXISTS(customer_info, '$.dataplan');
Find JSON enabled data.
select customer_info from customers
where JSON_EXISTS(customer_info, '$.dataplan');