Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.