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, 231🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...