How to check similarity between two strings in MySQL?

Similarity between two strings can be checked with the help of ‘strcmp()’ function. Here are the conditions.

• If both strings are equal, then it returns 0.

• If first string is less than the second string, it returns -1.

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

Here is an example.

Case 1 − If both 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 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 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)

Arjun Thakur

Updated on 26-Jun-2020 12:27:33

• Related Questions & Answers
• How to compute the Cosine Similarity between two tensors in PyTorch?
• Check if edit distance between two strings is one in Python
• Comparing two strings in MySQL?
• How to check if two strings are equal in Java?
• Java Program to check for equality between two strings ignoring the case
• How can we measure the similarity or distance between two vertices in a graph?
• Difference between two strings JavaScript
• How to add two or more strings in MySQL?
• How to check whether now() falls between two specific dates in MySQL?
• How to extract the strings between two words in R?
• How to compare two strings which are numbers in MySQL?
• What is the similarity between prepared statements and MySQL user variables?
• Which function in MySQL is used to add white spaces between two strings?
• Hamming Distance between two strings in JavaScript
• Java Program to Check if two strings are anagram