简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL 批量替换之replace语法的使用

WBOY
Release： 2016-06-07 17:06:35
Original
803 people have browsed it

实际需求中，需要对某张表某字段里面的内容进行批量替换，普通的思考流程如下： SELECT出来 str_replace替换 UPDATE写入 实际这

实际需求中，需要对某张表某字段里面的内容进行批量替换，普通的思考流程如下：

SELECT出来

str_replace替换

UPDATE写入

实际这样极其浪费资源以及消耗资源，MYSQL内置了一个批量替换的语法

  • 直接就替换了，后面也可以跟WHERE 条件语句

    支持多个词同时被替换

  • 很强大吧，后面那个一次性更换多个网上是没有的列子，，现在记录下来

    • Related labels：
    MySQL教程 MySQL 批量替换之replace语法的使
    source：php.cn
    Previous article：CentOS下无法正常获取数据库表数据的问题 Next article：Oracle 10.2.0.1 For CentOS 6.0 安装文档
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
    From 2024-04-06 14:53:12
    0
    1
    425
    MySQL procedure skips latest records I have the following three tables; hm_deliverylog+---------------------+------------------...
    From 2024-04-04 00:07:19
    0
    1
    360
    Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
    From 2024-04-03 19:24:44
    0
    1
    402
    PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
    From 2024-04-03 18:42:29
    0
    1
    420
    Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
    From 2024-04-03 14:46:04
    0
    1
    298
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn：Public welfare online PHP training，Help PHP learners grow quickly！