Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
strcmp()
On this page
The strcmp(v1, v2) function takes two string values.
It returns NULL if either input is NULL.
For example:
CREATE TABLE sc_r (t varchar(20));INSERT INTO sc_r VALUES('blue'), ('orange'), ('yellow');
SELECT r1.t, r2.t, strcmp(r1.t, r2.t) FROM sc_r AS r1, sc_r AS r2;
+--------+--------+--------------------+
| t | t | strcmp(r1.t, r2.t) |
+--------+--------+--------------------+
| blue | blue | 0 |
| blue | orange | -1 |
| blue | yellow | -1 |
| orange | blue | 1 |
| orange | orange | 0 |
| orange | yellow | -1 |
| yellow | blue | 1 |
| yellow | orange | 1 |
| yellow | yellow | 0 |
+--------+--------+--------------------+Caution
Implicit Collation
When character_ is set to utf8, string literals with characters using 4-byte encoding are implicitly assigned binary collation and processed as a sequence of bytes rather than characters.utf8mb4 character set.
For more information, refer to Implicit Collation in Special Cases.
Last modified: February 28, 2023