STRCMP

MySQL

Example

SELECT STRCMP("Hello", "World");

Output

-1

Explanation

In this example, the STRCMP() function compares two strings “Hello” and “World”. The result is -1 because “Hello” is less than “World” based on the ASCII value.