What is the use of trim in mysql
Xiaobian to share with you what is the use of mysql trim, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!
The trim function in mysql is used to filter the specified string in the format TRIM([{BOTH| LEADING | TRAILING} [remstr] FROM] str)】。
The trim function filters the specified string:
Full format: TRIM([{BOTH| LEADING | TRAILING} [remstr] FROM] str)
Simplified format: TRIM([remstr FROM] str)
Returns the string str where all remstr prefixes and/or suffixes have been removed. BOTH is assumed if none of the classifiers BOTH, LEADIN, or TRAILING is given. remstr is optional and spaces can be deleted if not specified.
mysql> SELECT TRIM(' bar '); -> 'bar'mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx'); --Delete the specified initial character x -> 'barxxx'mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx'); --Delete the first and last character x specified -> 'bar'mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz'); --Delete the specified trailing character x -> 'barx'
The left space removal function in mysql:
LTRIM(str);
mysql> SELECT LTRIM(' barbar'); -> 'barbar'
The right space removal function in mysql:
RTRIM(str):
mysql> SELECT RTRIM('barbar ');-> ' bar'; above is what is used in mysql trim all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!
