Skip to content

Latest commit

 

History

History
47 lines (36 loc) · 870 Bytes

strcmp.md

File metadata and controls

47 lines (36 loc) · 870 Bytes
title
STRCMP

Returns 0 if the strings are the same, -1 if the first argument is smaller than the second, and 1 otherwise.

Syntax

STRCMP(<expr1> ,<expr2>)

Arguments

Arguments Description
<expr1> The string.
<expr2> The string.

Return Type

BIGINT

Examples

SELECT STRCMP('text', 'text2');
+-------------------------+
| STRCMP('text', 'text2') |
+-------------------------+
|                      -1 |
+-------------------------+

SELECT STRCMP('text2', 'text');
+-------------------------+
| STRCMP('text2', 'text') |
+-------------------------+
|                       1 |
+-------------------------+

SELECT STRCMP('text', 'text');
+------------------------+
| STRCMP('text', 'text') |
+------------------------+
|                      0 |
+------------------------+