Using JSON Search Index with JSON_TEXTCONTAINS

The following example searches for customers having keyword “gold” in the description.

select customer_info
from customers
where JSON_TEXTCONTAINS(customer_info, '$.description', 'gold');