STRCMP

Assess the similarity between two strings.

SELECT STRCMP(“SQL Tutorial”, “SQL Tutorial”);

Definition and Usage

The STRCMP() function evaluates the relationship between two strings.

STRCMP(string1, string2)

Parameter	Description
string1, string2	Necessary. The pair of strings for comparison.

Works in:

From MySQL 4.0

Assess the relationship between two strings.

SELECT STRCMP(“SQL Tutorial”, “HTML Tutorial”);