JSON_TEXTCONTAINS and JSON_EXISTS are condicionals, typically used in a CASE expression or the WHERE clause of a SELECT statement to perfom a full-text search or ad hoc structural queries. This ...