1、按條件篩選,然後替換 select * from phome_ecms_tv where playurl like '%關鍵詞%';update phome_ecms_tv set myorder=REPLACE(myorder,'99','444') 2、刪除含某關鍵詞的內容 delete f ...
1、按條件篩選,然後替換
select * from phome_ecms_tv where playurl like '%關鍵詞%';
update phome_ecms_tv set myorder=REPLACE(myorder,'99','444')
2、刪除含某關鍵詞的內容
delete from phome_ecms_tv where playurl like '%關鍵詞%'
(delete+like執行命令,當'%%'中的關鍵詞為空時,會清空整個資料庫)