使用通配符来解决数据1和11、12/13/14的问题-白红宇的个人博客

发布日期：2022-03-15 04:11:22 浏览次数：56 分类：技术文章

本文共 1122 字，大约阅读时间需要 3 分钟。

update FOURxiaozhang set President23_1 = '1' WHERE President23 like '1|%';

update FOURxiaozhang set President23_1 = '1' WHERE President23 = '1';

update FOURxiaozhang set President23_2 = '1' WHERE President23 like '%[^1]2%';

update FOURxiaozhang set President23_3 = '1' WHERE President23 like '%[^1]3%';

update FOURxiaozhang set President23_4 = '1' WHERE President23 like '%[^1]4%';

update FOURxiaozhang set President23_5 = '1' WHERE President23 like '%[^1]5%';

update FOURxiaozhang set President23_6 = '1' WHERE President23 like '%[^1]6%';

update FOURxiaozhang set President23_7 = '1' WHERE President23 like '%7%';

update FOURxiaozhang set President23_8 = '1' WHERE President23 like '%8%';

update FOURxiaozhang set President23_9 = '1' WHERE President23 like '%9%';

update FOURxiaozhang set President23_10 = '1' WHERE President23 like '%10%';

update FOURxiaozhang set President23_11 = '1' WHERE President23 like '%11%';

update FOURxiaozhang set President23_12 = '1' WHERE President23 like '%12%';

update FOURxiaozhang set President23_13= '1' WHERE President23 like '%13%';

转载于:https://www.cnblogs.com/Eaglery/p/5065545.html

转载地址：https://blog.csdn.net/weixin_30536513/article/details/99812115 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！

下一篇：使用Logstash filter grok过滤日志文件

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！