mysql 正则匹配内容查询、拼接sql语句

-- -- 广告评论删除

-- SELECT count(ID) FROM t_article_comment WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]';
-- 
-- 
-- SELECT * FROM t_article_comment WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]';
-- 
-- 
-- SELECT count(tc.ID) FROM t_article_comment as tc LEFT JOIN t_app_user as tu on tu.ID = tc.CREATOR 
-- WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]';
-- 
-- 
-- SELECT tc.*,tu.ID as userID,tu.NICK_NAME,concat('UPDATE t_app_user SET `status`=2 where ID= "',tu.ID,'";') as sqltxt FROM t_article_comment as tc LEFT JOIN t_app_user as tu on tu.ID = tc.CREATOR 
-- WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]';


-- SELECT * FROM t_article_comment WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]';
-- 
-- DELETE FROM t_article_comment WHERE CONTENT REGEXP "[0-9]{8}" and CONTENT REGEXP '[^0-9.]'

-- 恢复评论数

-- update t_article set COMMENT_COUNT = where 

-- select ID, COMMENT_COUNT from t_article as t LEFT JOIN t_article_comment as tc on tc.ARTICLE_ID = t.ID;

select ARTICLE_ID,count(ID),CONCAT('update t_article set COMMENT_COUNT = ',count(ID),' where ID = "',ARTICLE_ID,'";') as sqlTxt from t_article_comment GROUP BY ARTICLE_ID;