# `Fun_JsonExistsColor_ByName` (function)


- **Type:** FUNCTION
- **Returns:** `int`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sJson` | `longtext` |
| 2 | IN | `sGetKey` | `varchar(100)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `Fun_JsonExistsColor_ByName`'`._

## Narrative

**Business context:** Color/ink lookup helper. Given a JSON array of objects (each carrying a `sName` field), returns 1 if any element's `sName` matches `sGetKey`, else 0.

**What it does:** Iterates the array with `JSON_LENGTH`/`JSON_EXTRACT`, unquotes each element's `$.sName`, returns 1 on first match.

**Invocation:** Status: appears orphaned. No caller found in any channel — no form-master, module-hook, other-routine, or xly-src reference. Candidate for maintainer audit.
