How to check similarity between two strings in MySQL?

You can check the similarity between two strings with the help of "strcmp()" function. The conditions are as follows.

• If the two strings are equal, 0 is returned.

• If the first strings are equal, 0 is returned. If the string is less than the second string, -1 is returned.

• If the first string is greater than the second string, return 1.

This is an example.

Case 1 - If two strings are equal.

The following is the query.

mysql > SELECT STRCMP("demo", "demo");

The following is the output of the above query.

+------------------------+
| STRCMP("demo", "demo") |
+------------------------+
| 0                      |
+------------------------+
1 row in set (0.00 sec)

Case 2 - If the first string is less than the second string.

The following is the query.

mysql> SELECT STRCMP("demo", "demo1234");

The following is the output of the above query.

+----------------------------+
| STRCMP("demo", "demo1234") |
+----------------------------+
| -1                         |
+----------------------------+
1 row in set (0.00 sec)

Case 3 - If the first string is greater than the second string.

The following is the query.

mysql> SELECT STRCMP("demo1", "demo");

The following is the output.

+-------------------------+
| STRCMP("demo1", "demo") |
+-------------------------+
| 1                       |
+-------------------------+
1 row in set (0.00 sec)

The above is the detailed content of How to check similarity between two strings in MySQL?. For more information, please follow other related articles on the PHP Chinese website!