代碼: 選擇全部
update prod set prod_name=replace(prod_name,'"','吋')WHERE prod_name LIKE '%"%'代碼: 選擇全部
mysql> update cust set addr = replace(addr,'鄉','區') where addr like '台中縣%';
Query OK, 95 rows affected (0.01 sec)
Rows matched: 157 Changed: 95 Warnings: 0
mysql> update cust set addr = replace(addr,'市','區') where addr like '台中縣%';
Query OK, 51 rows affected (0.00 sec)
Rows matched: 157 Changed: 51 Warnings: 0
mysql> update cust set addr = replace(addr,'鎮','區') where addr like '台中縣%';
Query OK, 11 rows affected (0.01 sec)
Rows matched: 157 Changed: 11 Warnings: 0
mysql> update cust set addr = replace(addr,'縣','市') where addr like '台中縣%';
Query OK, 157 rows affected (0.01 sec)
Rows matched: 157 Changed: 157 Warnings: 0
代碼: 選擇全部
mysql> update cust set addr = replace(addr,'市','區') where addr like '台北縣%';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update cust set addr = replace(addr,'台北縣','新北市') where addr like '台北縣%';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0