MySQL查询出的所有"SQL技巧"分类文章，在标题下方添加空行和特定文字。然后替换为特色图片!

服务器: xxx »数据库: xx »表: wpqi_posts

SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'SQL技巧'
AND p.post_type = 'post'
AND p.post_status = 'publish'

UPDATE wpqi_posts
SET post_content = CONCAT(
post_title,
'\n\n这是一个示例\n\n',
SUBSTRING(post_content, LOCATE(post_title, post_content) + CHAR_LENGTH(post_title))
)
WHERE ID IN (
SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'SQL技巧'
AND p.post_type = 'post'
AND p.post_status = 'publish'
);

UPDATE wpqi_posts
SET post_content = REPLACE(
post_content,
'这是一个示例',
'<img src="http://excelbook.cn/wp-content/uploads/2025/03/mysql.jpg" alt="MySQL技巧" style="max-width:100%;height:auto;">'
)
WHERE ID IN (
SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'SQL技巧'
AND p.post_type = 'post'
AND p.post_status = 'publish'
);

SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'Python学习'
AND p.post_type = 'post'
AND p.post_status = 'publish'

UPDATE wpqi_posts
SET post_content = CONCAT(
post_title,
'\n\n这是一个示例\n\n',
SUBSTRING(post_content, LOCATE(post_title, post_content) + CHAR_LENGTH(post_title))
)
WHERE ID IN (
SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'Python学习'
AND p.post_type = 'post'
AND p.post_status = 'publish'

);

UPDATE wpqi_posts
SET post_content = REPLACE(
post_content,
'这是一个示例',
'<img src="http://excelbook.cn/wp-content/uploads/2025/03/python.jpg" alt="Python技巧" style="max-width:100%;height:auto;">'
)
WHERE ID IN (
SELECT p.ID
FROM wpqi_posts p
JOIN wpqi_term_relationships tr ON p.ID = tr.object_id
JOIN wpqi_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wpqi_terms t ON tt.term_id = t.term_id
WHERE t.name = 'Python学习'
AND p.post_type = 'post'
AND p.post_status = 'publish'
);

学习资料见知识星球。

以上就是今天要分享的技巧，你学会了吗？若有什么问题，欢迎在下方留言。

快来试试吧，小琥 my21ke007。获取 1000个免费 Excel模板福利​​​​！

更多技巧， www.excelbook.cn

欢迎 加入 零售创新 知识星球，知识星球主要以数据分析、报告分享、数据工具讨论为主；