老张小站

执行以下SQL语句即可。说明：前面的大段代码，是在删除指定关键词的短消息前，先将 用户短消息索引表 / 短消息会话表 / 用户短消息状态表 中的相关记录清除，以免残留无用信息。

DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_0 WHERE uc_pm_indexes.plid=uc_pm_messages_0.plid AND uc_pm_messages_0.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_0 WHERE uc_pm_lists.plid=uc_pm_messages_0.plid AND uc_pm_messages_0.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_0 WHERE uc_pm_members.plid=uc_pm_messages_0.plid AND uc_pm_messages_0.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_1 WHERE uc_pm_indexes.plid=uc_pm_messages_1.plid AND uc_pm_messages_1.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_1 WHERE uc_pm_lists.plid=uc_pm_messages_1.plid AND uc_pm_messages_1.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_1 WHERE uc_pm_members.plid=uc_pm_messages_1.plid AND uc_pm_messages_1.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_2 WHERE uc_pm_indexes.plid=uc_pm_messages_2.plid AND uc_pm_messages_2.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_2 WHERE uc_pm_lists.plid=uc_pm_messages_2.plid AND uc_pm_messages_2.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_2 WHERE uc_pm_members.plid=uc_pm_messages_2.plid AND uc_pm_messages_2.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_3 WHERE uc_pm_indexes.plid=uc_pm_messages_3.plid AND uc_pm_messages_3.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_3 WHERE uc_pm_lists.plid=uc_pm_messages_3.plid AND uc_pm_messages_3.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_3 WHERE uc_pm_members.plid=uc_pm_messages_3.plid AND uc_pm_messages_3.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_4 WHERE uc_pm_indexes.plid=uc_pm_messages_4.plid AND uc_pm_messages_4.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_4 WHERE uc_pm_lists.plid=uc_pm_messages_4.plid AND uc_pm_messages_4.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_4 WHERE uc_pm_members.plid=uc_pm_messages_4.plid AND uc_pm_messages_4.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_5 WHERE uc_pm_indexes.plid=uc_pm_messages_5.plid AND uc_pm_messages_5.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_5 WHERE uc_pm_lists.plid=uc_pm_messages_5.plid AND uc_pm_messages_5.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_5 WHERE uc_pm_members.plid=uc_pm_messages_5.plid AND uc_pm_messages_5.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_6 WHERE uc_pm_indexes.plid=uc_pm_messages_6.plid AND uc_pm_messages_6.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_6 WHERE uc_pm_lists.plid=uc_pm_messages_6.plid AND uc_pm_messages_6.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_6 WHERE uc_pm_members.plid=uc_pm_messages_6.plid AND uc_pm_messages_6.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_7 WHERE uc_pm_indexes.plid=uc_pm_messages_7.plid AND uc_pm_messages_7.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_7 WHERE uc_pm_lists.plid=uc_pm_messages_7.plid AND uc_pm_messages_7.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_7 WHERE uc_pm_members.plid=uc_pm_messages_7.plid AND uc_pm_messages_7.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_8 WHERE uc_pm_indexes.plid=uc_pm_messages_8.plid AND uc_pm_messages_8.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_8 WHERE uc_pm_lists.plid=uc_pm_messages_8.plid AND uc_pm_messages_8.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_8 WHERE uc_pm_members.plid=uc_pm_messages_8.plid AND uc_pm_messages_8.message like '%关键字%';
DELETE FROM uc_pm_indexes USING uc_pm_indexes,uc_pm_messages_9 WHERE uc_pm_indexes.plid=uc_pm_messages_9.plid AND uc_pm_messages_9.message like '%关键字%';
DELETE FROM uc_pm_lists USING uc_pm_lists,uc_pm_messages_9 WHERE uc_pm_lists.plid=uc_pm_messages_9.plid AND uc_pm_messages_9.message like '%关键字%';
DELETE FROM uc_pm_members USING uc_pm_members,uc_pm_messages_9 WHERE uc_pm_members.plid=uc_pm_messages_9.plid AND uc_pm_messages_9.message like '%关键字%';
delete from uc_pm_messages_0 where message like '%关键字%';
delete from uc_pm_messages_1 where message like '%关键字%';
delete from uc_pm_messages_2 where message like '%关键字%';
delete from uc_pm_messages_3 where message like '%关键字%';
delete from uc_pm_messages_4 where message like '%关键字%';
delete from uc_pm_messages_5 where message like '%关键字%';
delete from uc_pm_messages_6 where message like '%关键字%';
delete from uc_pm_messages_7 where message like '%关键字%';
delete from uc_pm_messages_8 where message like '%关键字%';
delete from uc_pm_messages_9 where message like '%关键字%';