mysql的right函数_MySQL数据库中系统函数right功能简介

摘要：

下文讲述MySQL数据库中系统函数right的功能说明，如下所示；

系统函数right的功能:

right函数的功能:

用于截取指定字符串右边指定的字节数

right函数语法:

right(str,len)

-------参数说明------

str:待截取字符串

len:截取的字节数

------返回值说明----

返回从右边截取后的字符串

注意事项:

1.len大于字符串的总长度时，则返回全部字符串

2.len小于等于零时，返回空字符串

3.当str是中文时，则返回截取的字节数，如：一个中文占3个字节

right函数示例说明:

mysql> select right('maomao365.com',100);

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

| right('maomao365.com',100) |

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

| maomao365.com |

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

1 row in set (0.00 sec)

mysql> select right('maomao365.com',1);

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

| right('maomao365.com',1) |

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

| m |

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

1 row in set (0.00 sec)

mysql> select right('maomao365.com',0);

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

| right('maomao365.com',0) |

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

| |

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

1 row in set (0.00 sec)

mysql> select right('maomao365.com',-1);

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

| right('maomao365.com',-1) |

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

| |

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

1 row in set (0.00 sec)

mysql> select right('maomao365.com',-2);

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

| right('maomao365.com',-2) |

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

| |

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

1 row in set (0.00 sec)

mysql> select right('maomao365.com',3);

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

| right('maomao365.com',3) |

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

| com |

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

1 row in set (0.00 sec)

mysql> select right('猫猫教程',3);

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

| right('猫猫教程',3) |

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

| 程 |

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

1 row in set (0.00 sec)

mysql> select right('猫猫教程',10);

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

| right('猫猫教程',10) |

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

| 猫教程 |

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

1 row in set (0.00 sec)