mysql trim函数用法的小例子
mysql trim函数:
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str) , TRIM(remstr FROM] str)
Returns the string str with all remstr prefixes and/or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. If remstr is optional and not specified, spaces are removed.
例子,trim函数去除空格。
-> 'bar'
mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
-> 'barxxx'
mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
-> 'bar'
mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
-> 'barx'
您可能感兴趣的文章:
mysql trim函数用法的小例子
mysql怎么去除字段中换行符与回车符
mysql trim函数用法实例
mysql trim函数用法举例
mysql trim()函数用法实例
php trim函数实例代码
php trim函数用法实例
js trim函数的小例子
mysql实例 repeat语句的用法
php trim函数执行过程解析