mysql中trim函数的使用

TRIM([{BOTH|LEADING|TRAILING} [removed_str]] FROM str)

SELECT TRIM('  MySQL字符串函数  ') AS str1,

       TRIM('-' FROM '--MySQL字符串函数--') AS str2;

str1          |str2          |

--------------+--------------+

MySQL字符串函数|MySQL字符串函数|