Documentation

strings.compare() function

strings.compare() compares the lexicographical order of two strings.

Return values

ComparisonReturn value
v < t-1
v == t0
v > t1
Function type signature
(t: string, v: string) => int

For more information, see Function type signatures.

Parameters

v

(Required) String value to compare.

t

(Required) String value to compare against.

Examples

Compare the lexicographical order of column values

import "strings"

data
    |> map(fn: (r) => ({r with same: strings.compare(v: r.string1, t: r.string2)}))

View example input and output


Was this page helpful?

Thank you for your feedback!


New in InfluxDB 3.7

Key enhancements in InfluxDB 3.7 and the InfluxDB 3 Explorer 1.5.

See the Blog Post

InfluxDB 3.7 is now available for both Core and Enterprise, landing alongside version 1.5 of the InfluxDB 3 Explorer UI. This release focuses on giving developers faster visibility into what their system is doing with one-click monitoring, a streamlined installation pathway, and broader updates that simplify day-to-day operations.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On February 3, 2026, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2