# `Fn_spit_length` (function) > 根据分隔符 获取分割后对象个数 - **Type:** FUNCTION - **Returns:** `int` - **Deterministic:** NO - **SQL data access:** CONTAINS SQL ## Parameters | # | Mode | Name | Type | |---|---|---|---| | 1 | IN | `str` | `longtext` | | 2 | IN | `splitstr` | `varchar(5)` | ## Body _Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `Fn_spit_length`'`._ ## Narrative _No human-written narrative yet._