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, 228🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...