SELECT *
FROM `mt_asset`
WHERE `asset_file_path` LIKE '%"ほげ"を含まれるものを検索%'
UPDATE `mt_asset` SET asset_file_path=REPLACE (asset_file_path,'ほげ','ぴよへ')
WHERE `asset_file_path` LIKE '%ほげマッチ%'
\%r/ phpmyadmin上では 「\%r/」?
UPDATE `mt_entry` SET entry_atom_id=REPLACE (entry_atom_id,'develop/','')
WHERE `entry_atom_id` LIKE '%develop%'
これ参考
http://babyscript.blogspot.com/2008/03/mysql_27.html
FROM `mt_asset`
WHERE `asset_file_path` LIKE '%"ほげ"を含まれるものを検索%'
UPDATE `mt_asset` SET asset_file_path=REPLACE (asset_file_path,'ほげ','ぴよへ')
WHERE `asset_file_path` LIKE '%ほげマッチ%'
\%r/ phpmyadmin上では 「\%r/」?
UPDATE `mt_entry` SET entry_atom_id=REPLACE (entry_atom_id,'develop/','')
WHERE `entry_atom_id` LIKE '%develop%'
これ参考
http://babyscript.blogspot.com/2008/03/mysql_27.html
