Collections:
TRIM() - Trimming String
How to trim a string using the TRIM() functions?
✍: FYIcenter.com
TRIM(LEADING|TRAILING|BOTH remstr FROM str) is a MySQL built-in function that trims a string. For example:
SELECT TRIM(' dba.FYIcenter.com '); -- +--------------------------------+ -- | TRIM(' dba.FYIcenter.com ') | -- +--------------------------------+ -- | dba.FYIcenter.com | -- +--------------------------------+
Reference information of the TRIM() function:
TRIM(LEADING|TRAILING|BOTH remstr FROM str): modstr Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. remstr is optional and, if not specified, spaces are removed. Arguments, return value and availability: str: Required. The string that will be extracted from. LEADING|TRAILING|BOTH remstr FROM: Optional. Default is BOTH ' ' FROM. Specifies trimming behavior. remstr: Optional. The substring to be trimmed off. modstr: Return value. The modified string Available since MySQL 4.0.
Related MySQL functions:
⇒ UCASE() - Synonym for UPPER()
⇐ TO_BASE64() - Base64 Encoding
2023-11-12, 234🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...