MySQL STRCMP() Function

MySQL Functions : Compare two strings

Definition and Usage

The STRCMP() function compares two strings.

STRCMP(string1, string2)

Parameter	Description
string1, string2	Required. The two strings to be compared

If string1 = string2, this function returns 0

If string1 < string2, this function returns -1

If string1 > string2, this function returns 1

Works in:	From MySQL 4.0

Compare two strings:

SELECT STRCMP("SQL Tutorial", "HTML Tutorial");

Email:

Content: