MySQL STRCMP() Function

Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL STRCMP() Function
❮ MySQL Functions
Example
Compare two strings:
SELECT STRCMP("SQL Tutorial",
"SQL Tutorial");Try it Yourself »
Definition and Usage
The STRCMP() function compares two strings.
Syntax
STRCMP(string1, string2)Parameter Values
| Parameter | Description |
|---|---|
| string1, string2 | Required. The two strings to be compared |
Return Values
- If string1 = string2, this function returns 0
- If string1 < string2, this function returns -1
- If string1 > string2, this function returns 1
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Compare two strings:
SELECT STRCMP("SQL Tutorial",
"HTML Tutorial");Try it Yourself »
❮ MySQL Functions