Collections:
STRCMP() - Comparing Strings
How to compare two strings using the STRCMP() function?
✍: FYIcenter.com
STRCMP(str1, str2) is a MySQL built-in function that returns -1, 0, or 1 to indicate the sorting order two given strings. For example:
SELECT STRCMP('String', '$tring'); -- +----------------------------+ -- | STRCMP('String', '$tring') | -- +----------------------------+ -- | 1 | -- +----------------------------+
Reference information of the STRCMP() function:
STRCMP(str1, str2): int Returns 0 if the strings are the same, -1 if the first string is smaller than the second according to the sorting order, or 1 if the first is larger than the second. Arguments, return value and availability: str1: Required. The first string to be compared. str2: Required. The second string to be compared. int: Return value. -1, 0, or 1 indicating the sorting order. Available since MySQL 4.0.
⇒ SUBSTR() - Synonym for SUBSTRING()
⇐ SPACE() - Repeating Space Character
2023-11-13, 222🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...