Fun_GetNumFirst.md
1021 Bytes
Fun_GetNumFirst (function)
获取字符串中数字首次出现位置
- Type: FUNCTION
-
Returns:
varchar(100) - Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | str |
varchar(100) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunGetNumFirst'._
Narrative
Business context: First-digit-position locator — returns the 1-indexed position of the first 0-9 in str, or 0 if none. Catalog header: 获取字符串中数字首次出现位置.
What it does: Walks str char by char, regex-tests [0-9], returns the index on first hit.
Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep beyond the routine's own deployment SQL) — candidate for maintainer audit. Sibling Fun_GetNum is heavily used; this position-only variant has no current consumer.