乱爱性全过程免费视频/午夜毛片视频/中文字幕av三区/一级视频网址

當(dāng)前位置： 維易PHP培訓(xùn)學(xué)院 > MYSQL教程 > 內(nèi)容正文

MYSQL數(shù)據(jù)庫(kù)mysql trim函數(shù)用法實(shí)例

作者：VEPHP   時(shí)間 2017-09-27

《MYSQL數(shù)據(jù)庫(kù)mysql trim函數(shù)用法實(shí)例》要點(diǎn)：
本文介紹了MYSQL數(shù)據(jù)庫(kù)mysql trim函數(shù)用法實(shí)例，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。

導(dǎo)讀：一,mysql去除左空格函數(shù)：ltrim(str) returns the string str with leading space characters removed.例子： mysql> select lt...

一,mysql去除左空格函數(shù)：
ltrim(str)
returns the string str with leading space characters removed.MYSQL數(shù)據(jù)庫(kù)

例子：
?MYSQL數(shù)據(jù)庫(kù)

mysql> select ltrim(' barbar');
-> 'barbar'
this function is multi-byte safe.

二,mysql去除右空格函數(shù)：
rtrim(str)
returns the string str with trailing space characters removed.MYSQL數(shù)據(jù)庫(kù)

例子：
?MYSQL數(shù)據(jù)庫(kù)

mysql> select rtrim('barbar?? ');
-> 'barbar'MYSQL數(shù)據(jù)庫(kù)

this function is multi-byte safe.MYSQL數(shù)據(jù)庫(kù)

三,trim函數(shù)可以過濾指定的字符串：
完整格式：trim([{both | leading | trailing} [remstr] from] str)
簡(jiǎn)化格式：trim([remstr from] str)MYSQL數(shù)據(jù)庫(kù)

returns the string str with all remstr prefixes or suffixes removed. if none of the specifiers both, leading, or trailing is given, both is assumed. remstr is optional and, if not specified, spaces are removed.MYSQL數(shù)據(jù)庫(kù)

例子：
?MYSQL數(shù)據(jù)庫(kù)

mysql> select trim(' bar?? '); //默認(rèn)刪除前后空格
-> 'bar'
mysql> select trim(leading ',' from ',,barxxx'); //刪除指定首字符 如’,‘
-> 'barxxx'
mysql> select trim(both ',' from ',,bar,,,');? //刪除指定首尾字符
-> 'bar'
mysql> select trim(trailing ',' from 'barxxyz,,');
-> 'barxxyz'
?
mysql> select trim(' bar?? '); //默認(rèn)刪除前后空格
-> 'bar'
mysql> select trim(leading ',' from ',,barxxx');? //刪除指定首字符 如’,‘
-> 'barxxx'
mysql> select trim(both ',' from ',,bar,,,');? //刪除指定首尾字符
-> 'bar'
mysql> select trim(trailing ',' from 'barxxyz,,');
-> 'barxxyz'
?
mysql> update table set `field`=trim(trailing ',' from `field`) where where `field` like '%,';
this function is multi-byte safe.

mysql trim函數(shù)清除字段兩邊的空格：
?MYSQL數(shù)據(jù)庫(kù)

update zen_products setproducts_additional_image=trim(products_additional_image) where 子句

轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/6494.html


    標(biāo)簽：