为此,请使用MySQL REPLACE()。让我们首先创建一个表-mysql>createtableDemoTable
(
FolderLocationtext
);
使用插入命令在表中插入一些记录-mysql>insertintoDemoTablevalues('C/ProgramFiles/AllMySQLProgram');
mysql>insertintoDemoTablevalues('C/ProgramFiles/JavaChatApplication');
mysql>insertintoDemoTablevalues('C/ProgramFiles/Main/Image.png');
使用select语句显示表中的所有记录-mysql>select*fromDemoTable;
这将产生以下输出-+------------------------------------+
|FolderLocation|
+------------------------------------+
|C/ProgramFiles/AllMySQLProgram|
|C/ProgramFiles/JavaChatApplication|
|C/ProgramFiles/Main/Image.png|
+------------------------------------+
3rowsinset(0.00sec)
以下是在MySQL中执行查找和替换的查询-mysql>updateDemoTable
setFolderLocation=replace(FolderLocation,'C/ProgramFiles','E/MyFolder/Details');
Rowsmatched:3Changed:3Warnings:0
让我们再次检查表记录-mysql>select*fromDemoTable;
这将产生以下输出-+----------------------------------------+
|FolderLocation|
+----------------------------------------+
|E/MyFolder/Details/AllMySQLProgram|
|E/MyFolder/Details/JavaChatApplication|
|E/MyFolder/Details/Main/Image.png|
+----------------------------------------+
3rowsinset(0.00sec)