: TRIM : String Functions MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
String Functions
»
TRIM
»
422.1 .
If you wanted to trim leading and trailing characters, you would use the keyword BOTH
Hits: 949
422.2 .
SELECT TRIM(LEADING 'XXX' FROM 'XXXFileName')
Hits: 1083
422.3 .
The TRIM() function can trim spaces and characters or groups of characters.
Hits: 1011
422.4 .
TRIM(TRAILING 'xyz' FROM 'java2sxxyz');
Hits: 1047
422.5 .
TRIM(BOTH 'x' FROM 'xxxjava2sxxx');
Hits: 1033
422.6 .
TRIM(LEADING 'x' FROM 'xxxhava2sxxx');
Hits: 982
422.7 .
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)
Hits: 1071
MySQL TUTORIALS
String Functions
»
TRIM
Introduction
LPAD
ASCII
LTRIM
BIN
MAKE_SET
BIT_LENGTH
MID
CHAR
ORD
CHARSET
QUOTE
CHAR_LENGTH
REGEXP
CONCAT
REPEAT
CONCAT_WS
REPLACE
ELT
REVERSE
EXPORT_SET
RIGHT
FIELD
RPAD
FIND_IN_SET
RTRIM
FORMAT
SOUNDEX
HEX
SOUNDS LIKE
INSERT
SPACE
INSTR
STRCMP
LCASE
SUBSTRING
LEFT
SUBSTRING_INDEX
LENGTH
TRIM
LIKE
UCASE
LOAD_FILE
UNHEX
LOCATE
UPPER
LOWER
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
If you wanted to trim leading and trailing characters, you would use the keyword BOTH
