大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
MySQL常见的字符串函数
创新互联建站专注于企业全网营销推广、网站重做改版、广宗网站定制设计、自适应品牌网站建设、html5、购物商城网站建设、集团公司官网建设、外贸营销网站建设、高端网站制作、响应式网页设计等建站业务,价格优惠性价比高,为广宗等各大城市提供网站开发制作服务。
整理自官档。
SUBSTR(str,pos), SUBSTR(str FROM pos),SUBSTR(str,pos,len), SUBSTR(str FROM
pos FOR len)
SUBSTR() is a synonym for SUBSTRING().
SUBSTRING(str,pos), SUBSTRING(str FROM pos),SUBSTRING(str,pos,len),
SUBSTRING(str FROM pos FOR len)
The forms without a len argument return asubstring from string str starting at position pos.
The forms with a len argument return asubstring len characters long from string str, starting at
position pos. The forms that use FROM arestandard SQL syntax. It is also possible to use a negative
value for pos. In this case, the beginningof the substring is pos characters from the end of the
string, rather than the beginning. Anegative value may be used for pos in any of the forms of this
function.
For all forms of SUBSTRING(), the positionof the first character in the string from which the
substring is to be extracted is reckoned as1.
mysql> SELECTSUBSTRING('Quadratically',5);
-> 'ratically'
mysql> SELECT SUBSTRING('foobarbar' FROM4);
-> 'barbar'
mysql> SELECTSUBSTRING('Quadratically',5,6);
-> 'ratica'
mysql> SELECT SUBSTRING('Sakila', -3);
-> 'ila'
mysql> SELECT SUBSTRING('Sakila', -5,3);
-> 'aki'
mysql> SELECT SUBSTRING('Sakila' FROM -4FOR 2);
-> 'ki'
This function is multibyte safe.
If len is less than 1,the result is the empty string.
SUBSTRING_INDEX(str,delim,count)
Returns the substring from string strbefore count occurrences of the delimiter delim. If count
is positive, everything to the left of thefinal delimiter (counting from the left) is returned. If count
is negative, everything to the right of thefinal delimiter (counting from the right) is returned.
SUBSTRING_INDEX() performs a case-sensitivematch when searching for delim.
mysql> SELECTSUBSTRING_INDEX('www.mysql.com', '.', 2);
-> 'www.mysql'
mysql> SELECTSUBSTRING_INDEX('www.mysql.com', '.', -2);
-> 'mysql.com'
This function is multibyte safe.
CHAR_LENGTH(str) 返回字符数
Returns the length of the string str,measured in characters. A multibyte character counts as a
single character. This means that for astring containing five 2-byte characters, LENGTH() returns
10, whereas CHAR_LENGTH() returns 5.
LENGTH(str) 返回字节数
Returns the length of the string str,measured in bytes. A multibyte character counts as multiple
bytes. This means that for a stringcontaining five 2-byte characters, LENGTH() returns 10, whereas
CHAR_LENGTH() returns 5.
mysql> SELECT LENGTH('text');