zblog批量添加文章标签,sql语句根据文章标题添加标签
UPDATE zbp_post SET log_Tag = '{1}' WHERE log_Title LIKE '%鼠%'
UPDATE 表名 SET 标签列名= '标签' WHERE log_Title LIKE '%模糊匹配内容%'
UPDATE zbp_post SET log_Tag = '{1}{2}{3}{4}{5}' WHERE log_Title LIKE '%鼠%'
zblog批量添加文章标签,sql语句根据文章标题添加标签
UPDATE zbp_post SET log_Tag = '{1}' WHERE log_Title LIKE '%鼠%'
UPDATE 表名 SET 标签列名= '标签' WHERE log_Title LIKE '%模糊匹配内容%'
UPDATE zbp_post SET log_Tag = '{1}{2}{3}{4}{5}' WHERE log_Title LIKE '%鼠%'