How to compare two strings in SQL?

Question

Can anyone tell me how to compare two strings in SQL?

Answer 1

In SQL, we can compare two strings using STRCMP () function. STRCMP () returns ‘0’ when the two strings are the same, returns ‘-1’ if the first string is smaller than the second string, and returns 1 if the first string is larger than the second string.

Here is the syntax to use STRCMP () function:

STRCMP (string1, string2)

The following SQL query returns ‘0’ since both strings are same.

SELECT STRCMP (‘SQL tutorial’, ‘SQL tutorial’);

The following SQL query returns ‘-1’ since the first string is smaller than the second.

SELECT STRCMP (‘SQL tutorial’, ‘SQL tutorial blog’);

If you want to take a course that can provide Instructor-led training and certification, I recommend this SQL Training by Intellipaat.

You can master these SQL statements, queries and become proficient in SQL queries by enrolling in an industry-recognized SQL course.

Answer 2

You can use the equality operator ‘=’ for checking whether two strings are equal or not in SQL.

Here’s how you can implement it-

SELECT *You can use the equality operator ‘=’ for checking whether two strings are equal or not in SQL.

Here’s how you can implement it-

SELECT *

FROM table_name

WHERE string_col1 = string_col2;

FROM table_name

WHERE string_col1 = string_col2;