mysql中replace函数的使用方法_mysql数据库中系统函数replace的用法简介说明

摘要:

下文讲述mysql数据库中系统函数replace的用法简介说明，如下所示；

mysql之replace函数功能说明

replace函数功能:

将字符串中，指定字符串替换为特定字符串

replace函数语法:

replace(str,str1,str2);

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

str:源字符串

str1:待替换字符串

str2:替换后的字符串

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

将字符串str中的str1使用str2进行替换，

并输出替换后的结果

mysql之replace函数举例说明

mysql> select replace('maomao365.com','com','wang');)

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

| replace('maomao365.com','com','wang') |

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

| maomao365.wang |

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

1 row in set (0.00 sec)

mysql> select table_name,replace(table_name,'maomao','wangwang') from tables where table_name like 'maomao%' limit 10;

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

| table_name | replace(table_name,'maomao','wangwang') |

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

| maomao365.comC | wangwang365.comC |

| maomao_baidusubmit_sitemap | wangwang_baidusubmit_sitemap |

| maomao_baidusubmit_urlstat | wangwang_baidusubmit_urlstat |

| maomao_commentmeta | wangwang_commentmeta |

| maomao_comments | wangwang_comments |

| maomao_links | wangwang_links |

| maomao_options | wangwang_options |

| maomao_postmeta | wangwang_postmeta |

| maomao_posts | wangwang_posts |

| maomao_term_relationships | wangwang_term_relationships |

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

10 rows in set (0.00 sec)