| Parameter | Type | Description |
|---|---|---|
match_column | string, anyuri | Return the label of a match value |
Returns: string
Example
query:
SELECT LABEL_OF(us_state_or_territory) AS state
FROM just_states
LIMIT 10results:
| state |
|---|
| Virginia |
| Texas |
| Oklahoma |
| Virginia |
| South Carolina |
| California |
| Alabama |
| Maine |
| New Hampshire |
| Massachusetts |
This function is especially useful for cases where you need to ensure that the proper label is being returned (as opposed to the “blue bubble” uri)